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

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

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

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.

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

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

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

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

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