How to Make a Percentage Bar Graph in Excel (5 Methods)

In this article, we’re going to show you 5 methods of how to make a percentage Bar Graph in Excel. The Bar Graph is of 2 types- horizontal and vertical. In Excel, the Vertical Bar Graph is called the Column Graph.

To demonstrate our methods, we’ve taken a dataset containing 3 columns: Quarter, Brand, and Share. We’re working on the global shipment of smartphones in the last quarter of 2021, which is taken from a report from “Counterpoint research”.

how to make a percentage bar graph in excel


Download Practice Workbook


5 Ways to Make a Percentage Bar Graph in Excel

1. Make a Percentage Vertical Bar Graph in Excel Using Clustered Column

For the first method, we’re going to use the Clustered Column to make a Percentage Bar Graph.

Steps:

  • Firstly, select the cell range C4:D10.
  • Secondly, from the Insert tab >>> Insert Column or Bar Chart >>> select Clustered Column.

This will bring Clustered vertical Bar Graph. Now we’ll format our Graph to make it more beautiful.

We’ll change the Graph style here.

  • Firstly, select that Graph.
  • Secondly, from the Chart Styles button >>> select Style 16.

Moreover, we can Double-Click on the text “Share” to change the title of the Graph.

Here, we’ll hide the Gridlines.

  • Firstly, select the Graph.
  • Secondly, from the Chart Elements >>> unmark Gridlines.

how to make a percentage bar graph in excel

If we want to show the Data Labels, we can do that too.

  • Firstly, select the Graph.
  • Secondly, open the Chart Elements >>> from Data Labels >>> select Outside End.

Moreover, we can resize the Graph area.

  • Firstly, place the cursor on any corner of the Graph.
  • Secondly, drag it while holding the SHIFT key. This will keep the aspect ratio constant.

how to make a percentage bar graph in excel

Finally, we can change the label font sizes.

  • Firstly, select the element you want to be resized. We’ve selected the vertical axis labels.
  • Then, from the Home tab >>> change the parameters in the Font section.

Thus, we can change every element of the Graph. This is what our final version looks like.

how to make a percentage bar graph in excel

Read More: How to Display Percentage in an Excel Graph (3 Methods)


2. Applying Stacked Column to Make a Percentage Vertical Bar Graph in Excel

In this section, we’re going to use the Stacked Column to make a Percentage Bar Graph.

Steps:

  • Firstly, select the cell range C4:D10.
  • Secondly, open the Insert tab >>> from Insert Column or Bar Chart >>> select “More Column Charts…”.

This will bring up the Insert Chart dialog box.

  • Thirdly, from Column >>> Stacked Column >>> select the 2nd Graph.
  • Finally, press OK.

how to make a percentage bar graph in excel

This will display our vertical Bar Graph.

Now, we’ll perform additional formatting. We can move the Legend. To do that –

  • Select the Graph.
  • From the Chart Elements >>> Legend >>> select Right.

how to make a percentage bar graph in excel

Moreover, we can change the width of the Stacked Column.

  • Firstly, Double-Click on the Stacked Column.
  • Then, change the Gap Width. If we increase the value, the column will be narrower and vice versa.

Additionally, we can follow the formatting from the first method to further enhance our Bar Graph.

how to make a percentage bar graph in excel

Read More: How to Show Percentage Change in Excel Graph (2 Ways)


3. Make a Percentage Clustered Bar Graph

For this method, we’re going to make a Percentage Graph using Clustered Bar.

Steps:

  • Firstly, select the cell range C4:D10 and bring up the Insert chart dialog box as shown in method 2.
  • Secondly, from Bar >>> Clustered Bar >>> select the 1st Graph.
  • Finally, press OK.

how to make a percentage bar graph in excel

This will display our Clustered Bar Graph.

how to make a percentage bar graph in excel

Now, we’ll format the Graph.

  • Firstly, select the Bar Graph.
  • Secondly, from the Chart Styles >>> select Style 12.

Moreover, we can change the color of our style. To do that –

  • From the Chart Styles >>> Color >>> select “Monochromatic Palette 12”.

how to make a percentage bar graph in excel

We can do more formatting as shown in method 1. In conclusion, this is what our final percentage Clustered Bar Graph should look like.

Read More: How to Show Percentage in Excel Pie Chart (3 Ways)


4. Inserting Stacked Bar to Make a Percentage Graph in Excel

In this section, we’ll create the Percentage Bar Graph using Stacked Bar.

Steps:

  • Firstly, select the cell range C4:D10 and bring up the Insert chart dialog box as shown in method 2.
  • Secondly, from Bar >>> Stacked Bar >>> select the 2nd Graph.
  • Finally, press OK.

how to make a percentage bar graph in excel

This will display our Stacked Bar Graph.

Additionally, we can format this Graph as shown in method 1 and method 2.

how to make a percentage bar graph in excel


5. Using Funnel Chart to Make a Percentage Bar Graph in Excel

The Funnel chart is a kind of Bar Graph. We will use it in our final method to produce a Percentage Bar Graph.

Steps:

  • Firstly, select the cell range C4:D10 and bring up the Insert chart dialog box as shown in method 2.
  • Secondly, select the Funnel.
  • Finally, press OK.

This will output our Funnel Bar Graph.

how to make a percentage bar graph in excel

Moreover, we can format this Graph as shown in method 1 and method 2.


Practice Section

We’ve provided practice datasets for each method in the Excel file.

how to make a percentage bar graph in excel


Conclusion

We’ve shown you 5 methods of how to make a percentage bar Graph in Excel. If you face any problems, feel free to comment below. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo