MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is it possible to chart data from multiple spreadsheets? (nt)

Posted by Connie on September 13, 2001 9:36 AM

Posted by Russell Hauf on September 13, 2001 9:38 AM

Yes, it is (nt)

Posted by Connie on September 13, 2001 9:41 AM

Re: Yes, it is (nt)

Mind telling me how? I tried using Control to select the data but I wasn't having any success. It would only end up charting the last sheet that I selected from.

Posted by Russell Hauf on September 13, 2001 9:54 AM

Re: Yes, it is (nt)

Well, it really depends on what you want to graph and how your data is laid out. Truth be told, it would probably be easier to link your data to one sheet, but you can definitely have different series on different sheets.

If you are still confused, please provide a sample of your data and explain what you are trying to do.


Posted by Eric on September 13, 2001 12:46 PM

Try this using the graph wizard...

Select the first series you want to graph, hit the graph wizard button, select your chart type, and click "next". In step 2 of 4 "chart source data", click on the "series" tab and you will see that you have "series1" listed in the "Series" box on the middle left. Beside this are three input boxes, "name", "values", and "Category X axis labels". Notice that in the "values" box, the area you initially selected is represented.

Go back to the "series" area and click on the "add" button. A new series comes up, "series2", and its "values" is set to ={1}. Click on the red arrow icon to the left of the "value" box and navigate to the other worksheet or workbook that has the other range you want to add, and replace the ={1} with the range you want to graph. Then click the red arrow icon again and continue on with the wizard.

Once a graph is done, you can always add a new series from any other worksheet or open workbook by selecting the chart, right clicking on it, and selecting the "source data" option. It gives you the same dialogue as in the "series" tab of the graph wizard.

Hope that helps

Posted by Connie on September 14, 2001 6:44 AM

Thanks, Eric! That worked perfectly!