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
