Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Graphs/tables
|
|
|
The UK's most regular 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. |
Graphs/tables
Resolved · Low Priority · Version 2003
Reply Mon 15 Sep 2008, 16:23Delegate Lindsay said...
Lindsay has attended:
Powerpoint Introduction course
Outlook Advanced course
Graphs/tables
How do I import data from excel to create a graph in Powerpoint 2003?
For upcoming training course dates see: Pricing & availability
RE: Graphs/tables
Hello Lindsay
Thank you for your question and welcome to the forum.
You can import data from an Excel spreadsheet to create a chart in PowerPoint by doing the following:
1. Insert a chart layout slide.
2. Double-click on the chart area as indicated on the slide.
3. When the datasheet appears, click the Import File button on the toolbar at the top of the screen.
4. Navigate to and select the file containing the data you wish to import.
5. If the file contains more than one sheet, select the name of the sheet that holds the data you wish to import.
6. Select to import either the entire sheet, or type in the cell range for the data you wish to import, e.g. E4:J10
7. Ensure the 'Overwrite existing cells' box is checked and click OK.
The data from the Excel spreadsheet shows in the datasheet and in the chart created on the slide.
I hope this helps.
Amanda
|