Clustered Column Chart (Table of Contents)
Clustered Column Chart in Excel
The chart is the most important tools in excel for display the reports and dashboards, the benefit of a chart is may be a summarization of all business and or proactivity on a figure.
It is a graphical object used to represent the data in your Excel spreadsheet, there are many types of charts in excel. But clustered chart frequently usages in excel.
A clustered column chart is part of a chart in excel, it helps us displays more than one data series in a clustered vertical column, clustered column chart is very similar to a bar chart, except that clustered column chart allow grouping of bars for side by side comparison,
Vertical bars are showing in the group by category, we can also a comparison of multiple series by the help of cluster column chart, each data series show on same axis labels.
Steps to Make Clustered Column Chart in Excel
To do that we need to select the entire source Range including the Headings.
After that, Go to:
Insert tab on the ribbon > Section Charts > > click on More Column Chart> Insert a Clustered Column Chart
Also, we can use the short key, first of all, we need to select all data and then press the short key (Alt+F1) to create a chart in the same sheet or Press the only F11 to create the chart in a separate new sheet.
When we click on more column chart then we got a new window as below mention. We can choose the format then click on Ok.
How to Make Clustered Column Chart in Excel?
Clustered Column Chart in Excel is very simple and easy to use. Let understand the working of Clustered Column Chart with some examples.
Clustered Column Chart in Excel Example #1
There is a summarization of a data, this summarization is a performance report of a company, suppose some sales team in different location zone, and they have a target for sale the product. All filed like target, order count, Target, Order Value, Achieved %, Payment received, Discount % is given in the summary, Now we can see them in a table as below mention. So we want to display the report by using a cluster column chart.
First of all, select the range. Click on Insert Ribbon > Click on Column chart > More column chart.
Choose the clustered column chart > Click on Ok.
Also, we can use a shortcut key ( alt+F11).
This visualization is default by excel, if we want to change anything so excel allows to change the data and anything as we want.
If we see on the right hand so there is option ‘ + ’ sign, so with the help of ‘ + ‘ sign we can display the different chart elements which is we need.
When we use the chart and select then two tabs more display. ‘Design ‘and ‘Format ‘as ribbon,
We can format the chart and color themes layout of the chart, with the help of design ribbon tab.
Both ribbons are very useful for a chart. Eg: if we change the layout quickly then just click on the design tab and click on quick layout and change the layout of the chart.
If we want to change the color, then we can use a shortcut for changing the style and color of the chat just click on the chart and there is option highlighted as showing below mention.
Click on the style you want.
Chart also is given facility to filter the column which we do not need, similarly just click on the chart, at the right side, we can see the filter sign, as showing below mention pictures.
Now we can click on a column which we need to show in the chart.
Again we can change the data range also, Right click on the chart and select the data option then we can change the data also.
We can change axis, horizontally or vertically just click on switch row/column. We can also add or remove and edit a file.
We can also format the chart area just right click on the chart and select the format chart area option.
Then we get a new window on the right side as shown below.
Just click on chart option then we can all options of formatting the chart like chart title, Axis, legend, plot area, series and vertically.
Then click on the option which we want to format.
In the Next Tab, we also format the text.
Some more important things are like add data labels, show trend line in chat, we need to know.
If we want to show data labels as a percentage just right-click on a column and click on add data labels.
Data Label is added to the chart.
Also, we can show data labels with description. With the help of data callouts. Right click on column data column labels click on add data labels and click on add data callouts. The picture is showing below mentioned.
Data Callouts are added to the chart.
Sometimes we need trend analysis also on a chart. So right click on data labels and add the trend line.
A Trendline is added to the chart.
We can also format trend line.
If we want to format the gridlines, then right click on Gridlines and click on format gridlines.
Right Click on Gridlines and click on Add Miner Gridlines.
A miner Gridlines is added to it.
Right Click on Gridlines and click on Format Axis.
Finally, the Clustered Column Chart looks as given below.
Pros of a Clustered Column Chart in Excel
- Since a Clustered Column chart is a default Excel chart type, at least until you set another chart type as a default type
- It can be understood by any person and will look presentable who is not much more familiar with the chart.
- It helps us to make a summarization of a huge data in visualization, so easily we can understand the report.
Cons of Clustered Column Chart in Excel
- It’s visually complex when we add more categories or series.
- In one time more difficult to compare a single series across categories.
Things to be Remember
- All column and labels should be filled by various colors to highlight the data in our chart easily.
- Use self-explanatory chart title, axes titles. So by the title name, one can understand the report.
- If the data is relevant for this chart then use this chart otherwise the data is related to different categories, we can choose another chart type which is representable.
- No need of using extra formatting so that anyone can see and analyze all points clearly.
You can download this Clustered Column Chart Excel template here –Clustered Column Chart Excel Template
This has been a guide to a Clustered Column Chart in Excel. Here we discuss how to create the Clustered Column Chart in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in Excel –