Excel to PowerPoint Toggle Chart
Hi everyone,
I'm looking for some help ASAP. I have a data set currently in Excel and I am looking to chart this in PowerPoint. Currently I have a set of variables that I am toggling through and am looking to set up a similar format in PowerPoint that I have set up in Excel. Is this functionality available?
For example, I would like to be able to toggle through Q1, Q2, Q3, Q4 and have the chart update with the requisite data.
Quick note: we build our charts in PowerPoint instead of copying the link over from Excel.
Any advise is appreciated and the sooner the better... Thank you in advance!
On a slide can't you just create a chart, then when the excel document opens up for the data, just paste your data in there and then use the animations in order to toggle?
Not sure if a pivot chart is possible in Powerpoint, but why don't you just make 4 different slides? When you print a deck, you won't be able to toggle charts anyways.
Not really how powerpoint is built... You could link the chart in powerpoint to an excel document. then (assuming you are on the computer with the original excel file and the link is in tact), toggle the model in excel and update the chart in PPT.
Not sure if that's helpful, as you build you charts in PPT (not rly sure why you would do that honestly...?)
do you vba, and is this too late?
this is way too much effort for a simple task
Creating Powerpoint Charts with one source Workbook (Originally Posted: 06/10/2015)
Sorry if this has been answered before, but the question is a bit too nuanced for me to find an answer via search.
I'm working on a model and corresponding deck with a couple of references to follow. The example deck has all of the graphs on one source work book. In other words, all of the charts, pies, trendlines ect come from the same "Chart in Excel." This "Chart in Excel" mirrors the example model exactly.
I know how to link a chart or simply paste it, but this is new and I like it. In my experience links are pretty unreliable, so this is a way to easily update the charts, while keeping the Powerpoint free of links.
I understand how to edit the data on a single chart within Powerpoint and even add the entire model, but not how to create new charts using the same reference or make charts within that reference that then appear in Powerpoint
Any suggestions, help, or links to previous discussions would be appreciated.
Corrupti voluptatem ea nihil vero asperiores nisi nihil. Porro velit praesentium atque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...