How to Insert a Stacked Column Pivot Chart in Excel

Get FREE Advanced Excel Exercises with Solutions!

If we insert a Stacked Column chart from Pivot Table then it has some advantages instead of using a general Stacked Column. Such as Pivot Table provides the total sum for each section automatically and we’ll get it in our stacked column chart too. The inserting procedures are quite easy. You will learn the procedures to insert a Stacked Column Pivot Chart in Excel from this article with proper images for every step.


What Is Stacked Column Pivot Chart?

When we insert the Stacked Column chart from the Pivot Table instead of inserting it from the normal range then it is called a Stacked Column Pivot Chart.


How to Insert a Stacked Column Pivot Chart in Excel: Step-by-Step Procedures

Now we’ll learn the easy steps to make a Stacked Column Pivot Chart. Before starting get introduced to our dataset which represents the quarterly sales for three regions of a company.

First, we’ll convert a normal range to a Pivot Table then we’ll insert a Stacked Column Pivot Chart.

Steps:

  • Select any cell from the data range.
  • Then click as follows: Insert > Pivot Table.

How to Insert a Stacked Column Pivot Chart in Excel

Soon after, a dialog box will open up and it will automatically select the whole data range.

  • Mark the required worksheet option. I marked New Worksheet.
  • Next, just press OK.

How to Insert a Stacked Column Pivot Chart in Excel

After a while, a new worksheet will open up with PivotTable Fields.

  • Mark the quarters and Region options.

How to Insert a Stacked Column Pivot Chart in Excel

Soon you will see that a Pivot Table has been created as in the image below.

How to Insert a Stacked Column Pivot Chart in Excel

We have reached our final step- inserting a Stacked Column chart.

  • Click according to the serial: Insert > Insert Column or Bar Chart > Stacked Column.

Here’s our Stacked Column Pivot Chart. It is showing the sum of every quarter with different colors as a column. So from this graphical representation, we can easily understand the difference between the sum of quarters just by looking at a glance.

Read More: How to Add Grand Total to Stacked Column Pivot Chart


Customize Stacked Column Pivot Chart in Excel

Excel offers huge customization for your charts so that you can modify them according to your requirements. So now, we’ll learn some major and most useful customizations.


Hide All Field Buttons from Chart

Maybe you have already seen that the Pivot fields are also available in the Stacked Column Pivot Chart. This feature is not available in the general Excel Charts. So it’s one of the important advantages of the Stacked Column Pivot Chart. But if you think that it’s not necessary for you then you can easily hide it.

Steps:

  • First, right-click on any field name on the Pivot Chart.
  • After that, select the Hide All Field Buttons on Chart option from the appeared context menu.

How to Insert a Stacked Column Pivot Chart in Excel

Now see, all the fields are gone and the chart is looking clean.

Read More: How to Show Grand Total with Secondary Axis in Pivot Chart


Change Column Gap Width

If you want to change the gap between the columns then it is also possible in a Stacked Column Pivot Chart.  If we decrease the gap it may look better.

Steps:

  • Double click on any cluster of the stacked columns and a field named Format Data Series will appear on the right side of the Excel sheet.
  • Then set the gap from the Gap Width option. I set 20%.

How to Insert a Stacked Column Pivot Chart in Excel

See, the gap has decreased and the width of the columns increased.


Edit Cluster Border

For every cluster of the Stacked Column, you can create a border. Borders give a better look at the chart or you can highlight specific clusters by giving a border.

Steps:

  • Double click on the cluster to that you want to add a border.
  • Then click on the Fill & Line option.
  • Next, mark Solid Line, choose the desired color, and set the width. I chose black color and width- 1.75pt.

How to Insert a Stacked Column Pivot Chart in Excel

  • Do the same operation for the other clusters of the Stacked Columns.

Then your chart will look like the image below.


Format Vertical Axis

We can set the minimum and maximum bounds for the chart by formatting the vertical axis.

Steps:

  • Double click on the vertical axis to open the Format Axis field.
  • Later, set the minimum and maximum range. I kept the minimum bound at zero and set the maximum bound at 200000.

It’s the output image after setting the new bound.


Change Chart Design

Excel has some built-in chart designs. From there, you can choose your best-suited chart.

Steps:

  • Select the chart by clicking anywhere on the chart.
  • After that click on the Design ribbon and select your required chart design. I chose- Style 2.

How to Insert a Stacked Column Pivot Chart in Excel

Now have a look at this chart design showing the data of the vertical axis in it.


Change Color

In any chart design, you can change the colors of the cluster in the columns. So if you don’t like the default color of your chart then you can easily change them.

Steps:

  • Firstly, click as follows: Design > Change Colors and then select your desired color collections from the drop-down menu. I picked Colorful Palette 3.

How to Insert a Stacked Column Pivot Chart in Excel

Now you see, the new colors applied successfully and it’s looking pretty cool, right?


Download Practice Workbook

You can download the free Excel workbook from here and practice independently.


Conclusion

That’s all for the article. I hope the procedures described above will be good enough to insert a stacked column pivot chart in Excel. Feel free to ask any questions in the comment section and give me feedback.


Related Articles


<< Go Back to Pivot Chart | Pivot Table in Excel Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo