From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Stacked area PivotCharts

Stacked area PivotCharts - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

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…

Contents