Show Percentages in a Stacked Column Chart in Excel

This post will guide you how to show percentages in a stacked column chart in Excel. How to display percentages as series in an Excel Stacked column chart. How to create a 100% stacked chart with percentages in Excel.

Show Percentages in a Stacked Column Chart

Assuming that you have a list of data in the range of cells A1:D5 contain sales data for some product. And you want to create a stacked column chart with percentages based on those data. Just do the following steps:

#1 select the original data to create a stacked column chart.

#2 go to INSERT tab, click Insert Column Chart command under charts group, and select 2-D Column from the drop down list.

show percentage in chart2

#3 a stacked column chart has been created.

show percentage in chart3

#4 go to DESIGN tab, click Switch Row/Column command under Data group.

show percentage in chart4

show percentage in chart5

#5 go to Layout tab, click Add Chart Element command under Chart Layouts group. And then click Data Labels, select Center from the popup menu list.

show percentage in chart6

show percentage in chart7

#6 select one blank range and copy all product names into it.

show percentage in chart8

#7 you need to divide each value in the table above by the total value in the same row, so you can type the following formula into the formula box of cell B8 and then drag the fill handle over other cells to calculate the percentage values.


show percentage in chart9

#8 select those decimal numbers, and then go to HOME tab, click Number format drop down list under Number group. Or directly click % icon.

show percentage in chart10

All selected numbers have been changed to percentage format.

show percentage in chart11

#9 select one data label in the stacked column chart, and then type = in the formula bar, and then select percentage value, and press Enter key.

show percentage in chart12

You will see that the data label has been displayed as percentage. You need to repeat this step to change other data labels.



Leave a Reply