From the course: Excel: Mastering Pivot Table Dashboards and Reports
Join today to access over 24,900 courses taught by industry experts.
PivotCharts - Microsoft Excel Tutorial
From the course: Excel: Mastering Pivot Table Dashboards and Reports
PivotCharts
(electronic tones) - Okay, so far we've only been looking at the table of data by itself. We haven't visualized anything. So of course, pivot tables do allow you to visualize. They use a type of chart called a pivot chart. So if I click into my pivot table here, I don't have to highlight it, I can click on Pivot Chart right here. I can also insert a chart via the old methods, but it'll still default to a pivot chart type. So if I click on Pivot Table Analyze here, and I click on Pivot Chart, so this brings up kind of the older method of selecting a chart. I'll keep it as a column right here. Now the main difference between a pivot chart and a regular chart is that it will update based off of the type of interaction you do with it, right? And it also gives the user a little bit more buttons, which I actually like to take away. So we'll finish with that part. But what you can see here is if I click in here, and I…
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.