How do I plot data by drilling down through sheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top