How to Add Percentages to Excel Bar Chart

Excel is not only a useful tool for calculations but rather can be an awesome tool for presenting the data graphically.

To show our data like this, Charts are the most useful tool. We will present the charts and show you how can you add percentages to them in the example below.

Create Chart from Data

For our example, we will use the table with NBA players and their statistics from several categories: points, rebounds, assists, and turnovers:

Table

Description automatically generated

To create a basic bar chart out of our range, we will select the range A1:E8 and go to Insert tab >> Charts >> Bar Chart:

Chart

Description automatically generated with medium confidence

When we hover around this icon, we will be presented with a preview of our bar chart:

Graphical user interface, application

Description automatically generated

We will select a 2-D Column and our chart will be created:

Chart, bar chart

Description automatically generated

Add Percentages to the Bar Chart

If we would like to add percentages to our bar chart, we would need to have percentages in the table in the first place. We will create a column right to the column points in which we would divide the points of each player with the total points of all players.

Our table will look like this:

Graphical user interface, table, Excel

Description automatically generated

We will select range A1:C8 and go to Insert >> Charts >> 2-D Column >> Stacked Column:

Graphical user interface

Description automatically generated with medium confidence

Once we do this we will click on our created Chart, then go to Chart Design >> Add Chart Element >> Data Labels >> Inside Base:

Graphical user interface, application

Description automatically generated

Our chart will look like this:

To lose the colors that we have on points percentage and to lose it in the title we will simply click anywhere on the small orange bars and then go to Format >> Shape Styles >> Shape Fill >> No Fill:

Graphical user interface, application

Description automatically generated

Then we will click on the points percentage text in our bar chart and delete it:

Chart, bar chart

Description automatically generated

Now our bar chart looks like this:

Chart, bar chart

Description automatically generated

Clustered Column

It has to be noted that the easier and probably more convenient way to present this kind of data would be if we simply chose Clustered Column as our Chart type.

To do this, we will select our range again and then go to Recommended Charts in the Insert tab. When we click on it, Clustered Column will be the first option for us:

Graphical user interface, application

Description automatically generated

We will click OK and will have the chart that looks more natural for the thing that we want to present:

Chart, line chart, waterfall chart

Description automatically generated