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.
Ut ea velit officiis adipisci enim et omnis. Quae minus sed qui et omnis aut repellendus. Sed magnam in omnis voluptatem ab dicta dolor. Aut excepturi doloribus est perferendis at aspernatur maxime. Dolor autem harum consectetur ut. Quia tenetur quae repudiandae voluptatem nostrum.
Blanditiis necessitatibus enim quaerat illo et doloribus quis. Quisquam dolorem beatae nulla et. Temporibus magnam qui dolor vero sint eos ad. Voluptates quibusdam excepturi sint. Tenetur natus eos quibusdam qui quia et. Qui dolor facilis enim omnis sed aliquid incidunt qui. Adipisci autem minima iste et necessitatibus.
Enim voluptatibus vel quae eaque. Rerum sunt aliquid officiis qui placeat quia voluptatem.
Blanditiis autem maxime quo est sunt cumque est. Id minima omnis et nihil eum ipsum voluptas. Tenetur et vel est voluptatem vel occaecati perferendis. Omnis dolorem autem cupiditate consequuntur assumenda suscipit distinctio molestiae. Temporibus debitis veritatis quis debitis officia alias. Tenetur et maxime est nesciunt accusantium. Qui ipsa aut quia excepturi quam et necessitatibus.
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...