From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Linking to a table or chart

Linking to a table or chart

From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)

Start my 1-month free trial

Linking to a table or chart

“

- [Instructor] When we were copying and pasting our data from Excel, one of the objects that we pasted was pasted not as a table or a chart, but as a link. And here it is right here. We've animated this table to show really the sweep of the data during this quarter for mini solar panel sales. What I want to do now is have the ability to answer questions in the data itself. If I go to Slide Show and show this presentation from the current slide, remember it has an animation, so we'll animate it. I can then click this link that we created, Go to Excel. It says automatic updates of links has been disabled. I'm going to enable this content. And I want to go to my data and we have sliders here. So now I'm in a position to be able to answer my audience's questions. Somebody says, well, what did the sales look like in the Central U.S. region? And I can click on Central U.S. in order to be able to filter it with my slicer, but…

Contents