To unlink PowerPoint Chart from Excel, go to the “edit links to files” tab. This can be found under the “File” tab. Select the links that you want to break and you are done. Before unlinking the chart in PowerPoint from Excel, it is best to save a copy of the project.
Here is another way to do it: In Excel select one of the series on the chart, then select the whole SERIES formula on the Formula Bar and press F9, Enter. Do this for each series. The chart will now be static.
Click Formulas > Calculation Options > Manual, then when updating the original data in the range, the chart won't update anymore.
Slide.Shapes.AddChart()
automatically opens Excel. Even if I quickly do Chart.ChartData.Workbook.Application.Visible = false
, it still shows a little while. This makes automating chart creation error-prone as the user has to try not to touch the Excel applications that keeps popping up.
Opening a presentation with WithWindow = false
will still open Excel when creating new charts.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With