How do you chart data from multiple sheets within a workbook?

  • Thread starter Thread starter joeyej
  • Start date Start date
J

joeyej

How do you chart data from multiple sheets within a workbook? I'd like to create a line graph illustrating the increase in one cell's values across the many sheets in one workbook.

Thanks,

J
 
I don't believe the latter can be done. One can put line1 and line2
from different sheets on one chart. However, all points on line1 must
come from one sheet only; ditto for line2.
 
It can be done. I've used macros in the past to gather data which is
not sequentially located, then charted the result.

Do a Google Search for

..SeriesCollection(1).Values = Array(

That should get you started. Basically, you create array variables in
your macro then stuff them into the number series for your charts.
It's a bit of a pig to get your head around, but it does work.

Greg
 
It can be done.  I've used macros in the past to gather data which is
not sequentially located, then charted the result.
Click to expand...

Not sequentially located on *one* sheet, fine. Not sequentially
located on *more than one* sheet is a different matter.
 
Back
Top