From the course: Excel and PowerPoint: Creating High-Impact Financial Presentations
Join today to access over 24,900 courses taught by industry experts.
Charting with Pivots
From the course: Excel and PowerPoint: Creating High-Impact Financial Presentations
Charting with Pivots
- [Instructor] Now that we have our data summarized, we can convert it into a visual. Coming back to our pivot table, we could have jumped directly into a pivot chart straight from here, from the table, but because we've got the pivot table first, any chart that we create based on the pivot table is going to be automatically changed to a pivot chart. So if I go to recommended charts here and create a simple chart, it's going to automatically convert it into a pivot chart, and you can see all of the fields down here. So a couple of changes I'm going to make, I want to remove those fields here. I don't find them helpful so I am going to go to here and just remove them. If you ever accidentally remove your field list, can always get it back there just like you can with a pivot table. Okay, so a couple of other changes. I'm just going to add a data label, which I think looks nice. And once I've done that, I can remove labels on the y-axis so I can get rid of those there okay, looking…
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.