98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Charts
Charts
Resolved · Medium Priority · Version 2003
Michelle has attended:
Excel Intermediate course
Charts
How do you combine 2 or 3 different spreadsheets on to a chart?
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting only Text cellsTo select onlt text value cells in a spreadsheet, click on Edit-Go to(F5) |