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
|