Charts

Hi Michelle,

Thank you for your question.

As far as I can see you can't select ranges of data on different workbooks to create a chart when using the Chart Wizard.

However you can create a chart in one workbook based on one data range from another workbook. The next step would be to copy the additional data and return to your chart and paste the data using CTRL+V.

This is a possible second method:

In Book 1, I have regional heading(North and South) and years (1999 and 2000) with sales figures for both regions and years. In Book 2, I have the data for the East and West regions for the same years.

In Book 3 I start the chart wizard. Choose my chart type and continue to Step 2

Making sure my cursor is flashing in the data range box and then open up Book 1. I select my data including the headings and then swithch to the series tab. I can now see two series North and South. I now need to add the data from Book 2 to complete the four regions.

I firstly click Add a new series by clicking Add. I then place my cursor in the name box. Then I navigate to Book 2 using the Window Menu command and click on the cell that contains the label East. I then return to Book 3 and click in the Values box and using the Windows menu command, return to Book 2 and select the cells that contain the values for the East region. You then repeat the same procedure to add the data for the West.

I hope this has answered your question.

Regards

Simon