| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I plot data by drilling down through sheets?
I want to plot data down through sheets in stead of within a sheet. Quattro
Pro allowed me to do this but can't figure how to do it in Excel |
|
#2
|
|||
|
|||
|
MooseTrax,
You can chart non-contiguous ranges within a worksheet but not between sheets. Probably the best option is to create linked cells on a "master" sheet to your other sheets and then create the chart based on the data on the master sheet. ---- Regards, John Mansfield http://www.pdbook.com "MooseTrax" wrote: I want to plot data down through sheets in stead of within a sheet. Quattro Pro allowed me to do this but can't figure how to do it in Excel |
|
#3
|
|||
|
|||
|
This page may help explain how to set up a summary data range:
http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ MooseTrax wrote: I want to plot data down through sheets in stead of within a sheet. Quattro Pro allowed me to do this but can't figure how to do it in Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
| Importing data from several sheets, to one chart | Charts and Charting in Excel | |||
| How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
| creating names for data shown on a scatter plot | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Linear Mode
