Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Can someone help with my charting problem?

Posted by Jeremy Ward on April 06, 2000 5:57 PM

I want to chart a series range from the same cell in multiple worksheets.
If I was using cell A1 in say the 1st 3 worksheets, the entry I should make is:
=Sheet1:Sheet3!$A$1.
Why will it not accept this.
Any advice would be most gratefully accepted!
I look forward to hearing from some one out there!!

Regards
Jeremy

Re: Can someone help with my charting problem?

Posted by AB on April 07, 2000 8:11 AM

I've seen this asked enough to warrant the development of an example file showing how it can be done.

The solution I've been able to come up with involves using VBA to create an array of values which is force-fed to the chart series. Careful use of workbook and sheet event procedures can update the chart as values change.

Any suggestions for a better approach would be appreciated.

http:/geocities.com/aaronblood/examples/Series3D_Chart.xls

Re: Can someone help with my charting problem?

Posted by AB on April 07, 2000 8:20 AM

Sorry, don't know why the link feature didn't accept the URL in my last post?

Here's the link as it should appear:
http://geocities.com/aaronblood/examples/Series3D_Chart.xls

Re: Can someone help with my charting problem?

Posted by david Rainey on April 18, 2000 12:46 AM

Sorry i am new here but i had the same problem. I was forced to create a summary type page
where a1 would be equal to sheet 1 cell a1
and a2 would be sheet 2 cell a1
it worked very nicely for me.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.