This feature is used in the event where you have a fixed chart that points to a changing data source (for instance, a weekly sales report) which allows you to simply replace the data source and refresh your chart, rather than repeatedly copy and paste new data each time the chart needs an update.
Adult videochatroulette - Powerpoint chart data not updating
Stop updating chart by set as manual calculation Stop updating chart by inserting pivot table If you do not want the formula be manual, you can insert a pivot table based the data range first, and then insert a chart based the pivot table, and when the data range change, the chart cannot update. Select the data range you need, and click Insert Pivot Table. Then in the Create Pivot Table dialog, you can choose whether the pivot table is placed in a new worksheet or in the existing worksheet, here I check New Worksheet. Then click OK, and a pivot table will be inserted in a new sheet.
And then set the labels and values you need in the pivot table. Then select the pivot table, and click Insert tab and select a chart you need in the Chart group.
If you trust the source of the presentation, then choose to update the links.
All links to other documents will be updated with any new changes.
Choose the first radio button Use an Existing Named Range.
Select your desired named range from the drop down menu.When an excel chart is inserted in powerpoint the data och the chart is linked to an excel spreadsheet.In the windows version it is possible to change the source file of the linked data.Charts can add a little extra punch to your Power Point presentation instead of listing bullet points of data.Any chart created in Excel can be copied and pasted into your Power Point presentation.If the workbook file is large, multiple pastes like this can bloat your PPT file.