Catherine has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel charts
How can I create a chart in Excel on the same sheet as where the data appears, and then once it's done, export it to a Powerpoint slide, where I can edit it further if needed?
RE: Excel charts
Hi Catherine
Thank you for your question; and welcome to the forum.
You can crete a chart in Excel 2003 using the chart wizard which is a button on the standard toolbar (near the dropdown box to adjust zoom).
Select the data you wish to have illustrated in the chart from your spreadsheet; then click on the chart wizard button and follow through the 4 steps. The final step will allow you to choose to display the chart as an object in sheet X (X being the name of the sheet that the data is on). Then click Finish to display the chart.
To put the chart onto a PowerPoint slide and be able to edit the chart in PowerPoint, click near the edge of the chart area (box around the chart). Copy the chart; then go to PowerPoint.
In PowerPoint go to Edit - Paste Special and choose the Microsoft Excel Chart Object option and click OK. To edit the chart in PowerPoint, double-click on top of the chart and you will be able to do so.
I hope this helps.
Kind regards
Amanda
