From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a PivotChart
From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Create a PivotChart
- [Instructor] We know how to create pivot tables and we know how to create charts. Therefore, it should be relatively easy to create a pivot chart. Simply, click somewhere on the table that you want to create a chart for, click on PivotTable Analyze, click on the PivotChart button, and you'll see choices for how you might want to represent the information. Notice that as I select different items from the gallery, I get a preview and that some types of charts actually can't be created in a pivot table, including histograms, sunburst, but also tree maps, maps and so on. But, our basic chart types, columns lines, bars, pies, areas, and so on, not a problem. I want to create a Column chart and I would like to create a Stacked Column chart in this case. I'm going to click OK, there's my chart right there. Now you'll notice I have two pivot tables here and the reason I have to pivot tables is, that I want to create two…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.