Excel charts

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel charts

Catherine has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Catherine [1 post] (2008 May 20 Tue, 16:29) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	4	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel charts

by - trainer Amanda platinum contributer [947 posts] (2008 May 27 Tue, 13:30) Reply

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 charts

Related articles

Excel tip:

Editing Formulas in Excel Cells