From the course: Excel: Dashboards for Beginners
Join today to access over 24,800 courses taught by industry experts.
Visualize data with PivotCharts - Microsoft Excel Tutorial
From the course: Excel: Dashboards for Beginners
Visualize data with PivotCharts
- [Instructor] Now, once you've put your data into a PivotTable, the next thing you probably want to do is visualize it. So let's take a look at how we visualize data in a PivotTable. I can click anywhere inside this PivotTable, then I'm going to go to PivotTable Analyze. And over here, I'm going to click PivotChart. Now, Excel tries to be smart and figure out what kind of chart you want. I think we're happy with this Clustered Column chart. I'm going to go ahead and hit OK. Now, one weird thing is, you know, you may make a PivotTable that kind of looks like this here, and that might be fine for you, but when you visualize this data, it's clearly not right because we wouldn't want to just visualize the average like this, and we wouldn't want to visual the count, which is so small it doesn't make sense on this chart. Instead, what we probably want to do is just visualize the sum of the total. So watch what happens…
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.