From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 24,700 courses taught by industry experts.
Analyze data using PivotCharts
From the course: Excel: Working Together with Power Query and Power Pivot
Analyze data using PivotCharts
- Data in a table is pretty cool, but nothing speaks louder than when this data is presented in a chart. It's far more engaging this way. So let's go ahead and do it. Make sure that the Excel file for this video is open and that you're on the pivot worksheet. Excel makes it dead easy to create a chart from an existing pivot table, such as this one. And we do this using something called a pivot chart. Make sure that the pivot table is selected, well that you've clicked anyway in the pivot table and then select pivot table analyze and then pivot chart. Excel knows automatically how to go at what chart it thinks we want to create. Sometimes this magic works perfectly, but on this occasion, I actually want to select an area chart, and then the second option here, which is called a stacked area. And then go ahead and click on okay. As you can see in just a matter of moments, the chart has been created. What I'm going to do…
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.