From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Stacked area PivotCharts - Microsoft Excel Tutorial
From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Stacked area PivotCharts
- [Instructor] Okay, so up to this point, we've done a really nice job showing the composition of our data using charts like columns, pies and donuts, clustered and stacked bars. Now let's say we want to give some sense of trending as well, based on our release date data. So let's go ahead and copy one of our pivots, choose this third one, here, select the entire pivot table, Control-C, and then paste a fourth view down here beneath our stacked bar chart, and in this case, I'm going to update the view quite a bit, so instead of showing the number of titles now, I actually want to see how gross revenue moves. I'm going to use gross revenue as my values field, and instead of showing the data by genre and rating, I'm going to pull both of those fields out entirely and drag release date into my row labels. As usual, we get our auto grouping here, since Excel has identified this as a date-specific field, and in this case, that's a good thing, since the idea here will be to show data rolled…
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.
Contents
-
-
-
-
-
-
-
-
Intro to PivotCharts2m 26s
-
Bar and column PivotCharts4m 13s
-
Pie and donut PivotCharts5m 46s
-
Clustered bar PivotCharts3m 25s
-
Pro tip: Prevent charts from resizing4m 45s
-
Changing chart types on the fly3m 18s
-
Stacked area PivotCharts5m 46s
-
Chart layouts and styles4m 3s
-
Moving PivotCharts to new sheets2m 9s
-
Applying slicers to multiple charts5m 1s
-
Designing interactive dashboards13m 22s
-
-