Quote:
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!