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

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
 
M

merjet

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.
 
G

Greg Glynn

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
 
M

merjet

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

Create a chart from a table in word thats dynamic 0
Creating Network Diagram using a Chart SW integration 0
Formatting and copy or copy and formatting ?? 2
Creating a Chart on form from selected data in query. 0
Combine multiple sheets within workbook 1
Repeat the titles across multiple sheets of a workbook. 6
Macro to Format Multiple Sheets based on "Master" Format 0
How to append data from different sheet and different workbook? 2

Top