3 Examples to Create Clustered Bar Charts in Excel
Go to Insert in the ribbon and click on “Recommended Charts”
Step by Step of creating bar chart in Excel
To create a bar chart in Excel, follow these steps:
Step 1:
Select the data in the sheet. We will create an Inflation chart year by year (for demo only).
Step 2:
Go to Insert in the ribbon and click on “Recommended Charts”
Step 3:
In the “Insert Charts” dialog, click on the “All Charts” tab:
Step 4:
Click on the Bar on the left pane, “Clustered bar” is selected by default on the right.
We selected the third template.
Result:
Changing the chart title
To change the charge title, just click on it and delete the existing one.
Type your chart name. We give “Inflation Chart”, the title of our clustered bar chart:
Using another style for clustered bar chart
If you want to change the style of clustered bar chart then follow these two steps.
Step 1:
After selecting the chart that we just created, click on the “Brush” icon as shown below:
Step 2:
Under “Style” (selected by default), you can see the list of available styles.
We chose “style 8” and see the result:
Similarly, you may choose a different color scheme by going to “Color” option adjacent to the “Style”.
Just hover the mouse over various color schemes and Excel will show the impact on the chart real-time.
Adding/Removing chart elements
You may manage chart elements by clicking on the + icon after selecting the chart. A few elements are added by default like:
- Axes
- Chart Title
- Data Labels
- Gridlines
- Legend
- Trendline
Others are:
- Axis Titles
- Data Tables
- Error Bars
You may just check/uncheck to see the impact on the graph.