Re-Embedding Charts

[eljusticiero67]

Hello,

I am wondering if there is a solution out there around re-embedding charts that have been unlinked in a powerpoint deck. Essentially, I would like to right click a chart and have PowerPoint to recreate the embedded excel sheet based on the chart.

For example, if I have a pie chart that is 10% cars, 30% trucks, 60% motorcycles, this solution would just be able to create an embedded excel sheet linked to that chart with just those three elements and their relative values. Then I would just be able to change the values and have the changes reflected in the chart.

Since everything is there to make this happen, I feel like there must be a macro out there to create the charts. Without having to completely recreate it and then redo all the formatting.

Hope there is something out there! Thanks for everyone's help!!!

[eljusticiero67]

Originally Posted by Nuts & Bolts Taylor

I find it is easiest to work in the reverse order, keeping your excel data in a separate excel sheet and updating your PowerPoint document.

For quickly updating your charts, save a copy of your “formatted chart” as a Chart Template.

Save a Chart Template
After you have set your default formatting that you want to reuse later for your pie-chart

Step #1: right-click the chart and select “save as template”
Step #2: give the template a meaningful name so that it is easy to retrieve and distinguish

Apply a Chart Template
To apply the formatting to another chart that you later insert from Excel:

Step #1: right-click and select change chart type
Step #2: at the top left, select templates
Step #3: select your preformatted chart

Note about Linking
unless you absolutely have to, I would highly recommend not linking your charts to external excel sheets. In my experience this creates a massive version control issue when you are sharing your decks or renaming your excel models…either of which forces you to re-link your files, over and over again.

Thanks for the help! It is definitely ideal to have the original charts in excel format to edit. The only issue is when it comes to sharing PPT files. Often I am sent a PPT file with some minor issue in a chart, and all I want to do is change a pie slice in a pie chart from 22% to 20%-- but instead I have to ask them to resend with the correction made. Frustrating.

Any thoughts? Thanks!