Create a Clustered Stacked Column Pivot Chart in Excel

preview_player
Показать описание
Excel doesn't have a Cluster Stack chart type, but you can make a pivot chart with stacked columns that are grouped into "clusters".

Watch this video to see how to set up a pivot table, based on an Excel table with quarterly sales data.

Next, create a pivot chart, with region and year in the horizontal axis, and a stacked column for each year.

Get the sample file from my Contextures website:

Video Timeline

0:18 Excel Table
0:41 Make a Pivot Table
2:33 Add a Pivot Chart
3:04 Format the Chart

Instructor: Debra Dalgleish, Contextures Inc.
Рекомендации по теме
Комментарии
Автор

Thank you!! Very clear and easy to follow!! This helped me a lot!

Andrea_Cholico