Powerpoint bar chart not updating
In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot: 2.In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK. And the data range is formatted as a table, see screenshot: 4.Pasting as an image is not an option because there is always a chance that someone who is looking at that presentation might want to make some last-minute changes to the chart. Changing the wording of chart titles or something like that) Depending on the version of Office you have, you may get either linked or embedded Excel objects when you copy/paste from Excel. To be able to maintain each as a separate, independent chart, you'll want embedded charts.To do that, copy the chart in Excel, switch to PPT, and click the downward-pointing triangle under PASTE, choose Paste Special, make sure the Paste radio button is selected, not Paste Link, then choose the format you want to paste (e.g. That will embed the chart as an editable chart object that's independent of any other pastes you do from the same or other charts.
If you want to quickly export range contents from sheet to a graphic, please try to use the Kutools for Excel’s Export Range as Graphic as shown in the following screenshot.I have some Excel charts pasted as links in Power Point and regularly add new info to the Excel sheet and update the charts no problem. But the exact same chart in Power Point is messed up. However, just today, the y-axis on a couple of the charts is sitting right in the middle of the chart (instead of intersecting at the correct point). The drawback: this will embed a full copy of the entire workbook each time you do it.If the workbook file is large, multiple pastes like this can bloat your PPT file.