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