Bar Graph in Excel: Bar Graph is a type of chart that helps us to show the values in the pictorial representation. It is very easy to create a Bar Graph in Microsoft Excel. In this article, we will show you how to create a Bar Graph on Microsoft Excel.
Creating a Bar Graph:
For creating a bar graph, you must need sample values that need to converted into a pictorial graph. Let us consider sample values as shown in the below image:
From the above image, the numerical values have been added from the cell G5 to G10. The sum of the cell G5 to G10 has been stored in the cell G13. The percentage of values has been stored in cell G16.
Create Bar Graph for Percentage:
- Select the cell G16 which contains the percentage
- Now, go to the option “Insert” & click “Bar Graph” to create the bar graph for the given value.
- Click the Bar Graph icon to create the Bar Graph
From the above image, You can able to see the bar graph created for the value “Percentage“.
How To Customize Bar Graph in Excel:
You can customize the following options of the Bar Graph in Excel:
- Chart Title
- Data Labels
- Data Table
Edit Chart Title:
Once you created the Bar Graph, go to the option “Chart Title” which is located in the “Insert Menu“.
The Chart Title option contains three options and they are None, Centered Overlay Title, Above Chart.
If you haven’t given the name to the graph and then you can give the new name by clicking the “Edit Chart Title..” option.
- None: Do not display the chart title.
- Centered Overlay Title: Overlay centered Title on a chart without resizing a chart
- Above Chart: Display Title at top of the chart area and resize a chart
Example for Centered Overlay Title is,
The list of options available in Legend is:
Example of “Show Legend at Right” option is,
The list of options available on Data Labels option is,
The example of “Centre” data label value is,
The list of options available on Data Table is,
The example of “Show Data Table” option is,
There are two types of Axis options available in Microsoft Excel.
- Primary Horizontal Axis
- Primary Vertical Axis
You can select any of those options to change the axis of the bar graph.
Follow the above steps to create the Bar Graph using Microsoft Excel. If you have any queries related to this tutorial and then comment us below.
- Article Explanation
- Images Explanation
- Steps Involved
- Customising Methods
Kindly visit our Homepage for more articles.