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.
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.
Not sequentially located on *one* sheet, fine. Not sequentially
located on *more than one* sheet is a different matter.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.