Excel graphs in PPT

Resolved · Medium Priority · Version 2007

Fri 16 Sep 2011, 17:04 Delegate 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

Mon 19 Sep 2011, 10:54 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

PowerPoint tip:

Drawing lines in slide show

To draw straight lines in your slide show presentation, either horizontal and vertical lines, hold down the shift key and with the Mouse / pen highlighter, drag.

View all PowerPoint hints and tips