MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graphing from multiple worksheets


Posted by Scott on August 08, 2001 8:27 PM

I have a workbook that contains four worksheets of identical data, and a fifth worksheet that is used for totals. How can I create a graph that uses data from the same cell in different worksheets?


Posted by AB on August 09, 2001 6:44 AM

I'll just come right out and say it.
Normally, you can't.

Yet another Excel chart limitation.

Stange though you'd really think a 3D reference as a series range would be OK. At this point we should probably give up on the idea.

However, I've got an example on my website that shows how VBA can forcefeed a 3D array to a chart series. Works pretty good.

You can review the example file in the VBA section of my website look for:
series_3d_chart.zip

Regards,
AaronThe Excel Logic Page