excel charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel charts

Excel charts

resolvedResolved · Low Priority · Version 2003

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


 

Excel articles

Please browse our web site to find out more about
excel+training and other training courses.

Excel tip:

Selecting blank cells within a range of data

Select 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.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

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

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.1 secs.