How do I plot data by drilling down through sheets?

[MooseTrax]

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

 

[John Mansfield]

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.

 

[Jon Peltier]

This page may help explain how to set up a summary data range:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______