How to Create a 2D Clustered Column Chart in Excel

Column charts help to analyze and compare data. By creating a 2D clustered column chart in Excel, users can compare data from different variables. In this article, we will show you how to create a 2D clustered column chart in Excel.


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


2 Easy Ways to Create a 2D Clustered Column Chart in Excel

Sometimes, users use more than one variable in their data set in Excel and want to describe them more meaningfully. Here they must use clustered column charts, as only column charts can be used with one variable. Using a 2D clustered column chart in Excel for this purpose is more meaningful. In this article, you will see two easy ways to create a 2D clustered column chart in Excel. In the first method, we will insert the data set into the Chart group to create a 2D clustered column chart, and in the second approach, we will apply Visual Basic Applications (VBA) for the same purpose. We will use the following data set for both the procedures.

Easy Ways to Create a 2D Clustered Column Chart in Excel

1. Inserting Data Set to Chart Group to Create a 2D Clustered Column Chart

In this method, we will insert our data set into the Chart group of the Insert tab to create a 2D clustered column chart in Excel. Go through the following steps for this method.

Step 1:

  • Firstly, select your entire data set.
  • For instance, in our example it is B4:D10.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 2:

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 3:

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 4:

  • Finally, you will be able to create a 2D clustered column chart.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 5:

  • Furthermore, you can make your chart more attractive by using the Style icon beside the chart.

Easy Ways to Create a 2D Clustered Column Chart in Excel

  • Consequently, the 2D clustered column chart will look more attractive.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Read More: Column Chart vs Bar Chart in Excel (6 Useful Examples)


2. Applying VBA to Create a 2D Clustered Column Chart

Aside from inserting the data set into the Chart group, you can also apply Visual Basic for Applications (VBA) to create a 2D clustered column chart in Excel. You can go through the steps below to understand the whole procedure.

Step 1:

  • First of all, take the following data set to apply VBA.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 2:

  • Secondly, go to the Developer tab in the ribbon.
  • Then, choose the Visual Basic command from the Code group.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 3:

  • Thirdly, you will see a new tab after choosing the command.
  • From there, choose Module from the Insert tab.

Easy Ways to Create a 2D Clustered Column Chart in Excel

Step 4:

  • Fourthly, paste the following VBA Code into the Module.
Sub Create_a_2D_Clustered_Column_Chart()
'Declare range of selection
Range("B4:D10").Select
ActiveSheet.Shapes.AddChart.Select
'Set the data source
ActiveChart.SetSourceData Source:=Range("'VBA'!$B$4:$D$10")
'define the chart type
ActiveChart.ChartType = xlColumnClustered
'declare activation command
ActiveSheet.ChartObjects(1).Activate
ActiveSheet.ChartObjects(1).Cut
'define the chart destination
Sheets("VBA").Select
ActiveSheet.Paste
'return to current worksheet
Sheets("VBA").Select
Range("E5").Activate
End Sub

Easy Ways to Create a 2D Clustered Column Chart in Excel

  • Then, save this and press the play button to run the code.

Sample Data Set

Step 5:

  • Finally, you will create the 2D clustered column chart by applying VBA.

Sample Data Set

Step 6:

  • Furthermore, you can change the color and appearance of your chart by using the Style icon.

Sample Data Set

  • Lastly, you can get your desired chart by going through these steps.

Sample Data Set

Read More: How to Insert a 3D Clustered Column Chart in Excel (with Easy Steps)


Conclusion

That’s the end of this article. I hope you find this article helpful. After reading this article, you will be able to create a 2D clustered column chart in Excel by using any of the methods. Please share any further queries or recommendations with us in the comments section below.


Related Articles

Araf
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo