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.
 

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.

Ask a Question

Similar Threads

How do I copy Chart shee to other workbook without external refere 2
searching for text within shapes 3
Repeat the titles across multiple sheets of a workbook. 6
Copying a chart included in a range 1
Copy charts and remove links to original source data 12
Macro to create charts - Points to wrong sheet 3
Combine multiple sheets within workbook 1
Why do charts disappear? 2

Back
Top