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 |