PC Review


Reply
Thread Tools Rate Thread

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

 
 
joeyej
Guest
Posts: n/a
 
      23rd Mar 2012
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

 
Reply With Quote
 
 
 
 
merjet
Guest
Posts: n/a
 
      25th Mar 2012
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.

 
Reply With Quote
 
 
 
 
Greg Glynn
Guest
Posts: n/a
 
      26th Mar 2012

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
 
Reply With Quote
 
merjet
Guest
Posts: n/a
 
      26th Mar 2012

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you link chart source data when you copy the chart? =?Utf-8?B?bWFtYWdpcmw=?= Microsoft Excel Charting 1 8th Dec 2006 03:40 AM
Chart sheets cause data sheets to be blank =?Utf-8?B?SmFjaW50aGU=?= Microsoft Excel Charting 2 29th Apr 2005 02:18 PM
Re: Question??? You know when you double click in a username field you see your previous entries? How do you reset this so you can see your entries again. Thorsten Matzner Windows XP New Users 0 5th Jun 2004 04:34 PM
Question??? You know when you double click in a username field you see your previous entries? How do you reset this so you can see your entries again. =?Utf-8?B?Y2hyaXM=?= Windows XP General 1 3rd Jun 2004 08:17 PM
Help with copying data from multiple sheets to multiple sheets Randy Reese Microsoft Excel Programming 1 18th Mar 2004 11:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:21 AM.