excel graphs ppt
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Excel graphs in PPT

Excel graphs in PPT

resolvedResolved · Medium Priority · Version 2007

replyReply Fri 16 Sep 2011, 17:04Delegate William said...

William has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course

Excel graphs in PPT

I copy a chart from excel to PPT. For e.g. a chart showing rainfall from Jan to Dec. If i update the data for Jan this is auto changed in PPT. However if I add another month (say the following Jan) or a chart title this does not get included in PPT. why?

thanks

For upcoming training course dates see: Pricing & availability

replyReply Mon 19 Sep 2011, 10:54Trainer Simon said...

RE: Excel graphs in PPT

Hi William,

Thank you for your question.

As the chart is based on an underlying range of data, if any of that data range is changed then the PowerPoint chart will update automatically. If you were to add a new column within the original data range then the chart in PowerPoint will update automatically.

However if you add a new column outside that original range you need to update the data range in PowerPoint.

1. Select the Chart in PowerPoint and go to the Design Tab.
2. Choose Select Data from the Data Group.
3. Edit the range to include the new column of data in the Chart Data Range box.

The PowerPoint graph will now update.

I hope this answers your question. Please let me know.

Regards

Simon

Sun 25 Sep 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
advanced power point and other Microsoft training courses.

Powerpoint tip:

Coping slides quickly

Rather than using insert / files, have both presentations open.
1. Windows / arrange all
2. In the Slide view drag the slide you want to copy, and drop it in the other slide view.
3. Then use the smart tag to decide if you keep the formatting.

View all Powerpoint hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard