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).

Excel-bar-Clustered-data

Step 2:

Go to Insert in the ribbon and click on “Recommended Charts

recommended

Step 3:

In the “Insert Charts” dialog, click on the “All Charts” tab:

All-charts

Step 4:

Click on the Bar on the left pane, “Clustered bar” is selected by default on the right.

clusrered-chart

We selected the third template.

Result:

clusrered-chart-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:

clusrered-chart-title

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:

clusrered-chart-style

Step 2:

Under “Style” (selected by default), you can see the list of available styles.

We chose “style 8” and see the result:

clusrered-chart-style-

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.

clusrered-colors

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.