MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.

AB

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

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

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.