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.

Clustered bar PivotCharts

Clustered bar PivotCharts - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Clustered bar PivotCharts

“

- [Instructor] So we practiced building basic column and pie or donut charts to show titles by genre or rating. Now let's try showing both dimensions together. So let's plan to add a third chart to the sheet by selecting our second PivotTable. Going into our tools, selecting the entire table, ctrl+C to copy it, and then ctrl+V to paste a third independent PivotTable, and this one we can go ahead and name titles by genre and rating. Just to make it super clear what we're trying to show here. Now again, exactly what I'm trying to show is the breakout of titles by both genre and rating in the same chart. So in this case, using a cluster column or a cluster bar chart, will be a really great option for us. So let's go ahead and drag genre out of the filters view, and into our column labels, while keeping rating as our row labels. Now when we do that, I scroll up, you'll see that it totally squished our existing charts. And that's happening because Excel is autofitting these column widths…

Contents