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