In the example below, you can see that as soon as I add new data, the Excel Table expands to include this data as a part of the table (note that the border and formatting expand to include it in the table).
Now, we need to use this Excel table while creating the charts.
Then the charts don't resize in PPT when the links are updated.
Here are the exact steps to create a dynamic line chart using the Excel table: That's it!
The above steps would insert a line chart which would automatically update when you add more data to the Excel table.
To correct this, drag the blue mark at the bottom right of the Excel table to remove the deleted data points from the table (as shown below).
While I have taken the example of a line chart, you can also create other chart types such as column/bar charts using this technique.
Better if you create custom size chart pages in Excel so you don't have to resize the devils in PPT. worksheets is that the size information seems to be somehow embedded in the upper left hand corner of the chart.
Now, that upper left hand corner is always "visible" to the linking mechanism during update links since a chart sheet is 100% "visible".When you create a chart in Excel and the source data changes, you need to update the chart's data source to make sure it reflects the new data.In case you work with charts that are frequently updated, it's better to create a dynamic chart range.Now, stay with this one, it splits into two thoughts now.a) if the "upper left hand corner of the chart is not visible" in what would be the Active Window of the spreadsheet (if it were open), the update linker won't see it and may not update the chart, or worse, may chop off part off the chart image. b) the second issue is the Active Window zoom factor, if you are really going to insist on putting charts on worksheets (more on that later).Now a worksheet may not be 100% "visible" if you stuck the charts all over the place in a worksheet.