Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel charts
Resolved · Low Priority · Version 2003
Catherine has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
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?
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
|
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
We'll call during UK business hours
Server loaded in 0.1 secs.