How to Plot Bar Graphs in Excel?

Microsoft Excel – Plotting Bar Graphs


A graph is a diagram that shows the relationships between two or more things. Bar graphs, pie charts, linear graphs, etc are some examples of a graph. Graphs are very useful tools to present the data in a meaningful way.

Bar Graph

A bar graph is a diagram with rectangular bars. The graph usually compares or shows the relationship between two different categories.

Let us take an easy example to see how can we plot a bar graph. I am using Excel 365 application but the same steps can be followed in other excel versions too.

Step 1: Make the Data Table

Our requirement is the data where 2 Categories are related. We have taken some random data as shown below i.e prices of the various articles.

Step 2: Select the table and Go to Insert option in the Menu of the Excel application window.

Step 1: How to plot a bar graph

Step 3: Go to Charts where all the graph options are available. Select the ‘Bar Graph’ option.

Different types of bar graphs

Step 4: Choose the bar graph style as per your requirements or choice. You will see your bar graph ready on the same sheet at the center.

Bar graph showing the price of various articles in the rectangular form.
You can edit the design and color as per your choice from the option visible at the top-right corner.
Editing options for the bar graph.
If you wish to make the bar graph more informative or decorative then you can add various other details from the options as shown below.
Extra options to add other information.
So play with the options available to learn more. Make changes and see how the graph is responding.
Check the Modified bar graph after using various options.
Decorated Bar Graph
The best way to learn is to try all the options and you will know everything about the bar graphs in Excel.
Happy Bar Graphing!

Leave a Reply