How to Create Graphs in Excel with Multiple Columns (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, you will learn various easy methods to create graphs in Excel with multiple columns. Vertical bars are used in column charts to compare values between different categories of data. The main purpose of the column chart is to organize your data in a clear way. Then you can analyze it and communicate the insights easily. Finally, I will also show you some formatting options to modify your graphs.


Watch Video – Create Graphs in Excel with Multiple Columns



How to Create Graphs with Multiple Columns in Excel: 3 Easy Methods

Column charts with multiple columns are actually very easy to create. Most users are highly familiar with column charts. So, it is a sensible option to present your data in column charts with multiple columns. We will demonstrate 3 methods to create graphs in Excel with multiple columns. Let us see them one by one below.


1. Create 2D Graph with Multiple Columns in Excel

In the first method, we will create a 2D graph in Excel with multiple columns. For this method, we are using a dataset of monthly income. So, we have two variables in our dataset.

Create a 2D Graph with Multiple Columns in Excel

Steps:

  • First of all, click on cell B4.
  • Now, while you are on cell B4, press Ctrl+Shift+Down arrow.
  • Then, while pressing Ctrl+Shift, press the Right arrow. So, this will select the whole data table.

Create a 2D Graph with Multiple Columns in Excel

  • Afterward, go to the Insert tab and click on the Chart option.
  • Then, click on the Stacked Column option.

  • Finally, you will get the graph with multiple columns.

Read More: How to Create a Variable Width Column Chart in Excel


2. Insert 3D Graph in Excel with Multiple Columns

The method that I am going to show you now, is the 3D column chart with multiple columns. In this type of chart, the vertical columns are extended to all three axes, namely X, Y, and Z. As you can expect, we have 3 variables in our dataset for this method. They are Name, January, and February. The dataset shows the changed salary of 4 people from January to February. So, let us see the steps to create a 3D chart from this dataset.

Insert a 3D Graph in Excel With Multiple Columns

Steps:

  • At the start of the method, select your dataset with the help of the keyboard shortcuts that I showed you before.
  • Additionally, you can use your mouse to click and drag over the dataset. This will also highlight your data.
  • Now, navigate to the Insert tab and select the 3D Column as the image shows below.

Insert a 3D Graph in Excel With Multiple Columns

  • Finally, this will insert a 3D column chart beside your dataset.

Read More: How to Change Width of Column in Excel Chart


3. Create Graph with Clustered Multiple Columns in Excel

The clustered column chart is suitable where we have more than two variables. The dataset for this method has the exam marks of four students for Physics and Maths. With the help of the clustered chart, we will be able to easily compare the marks of the two subjects for each student. We can also compare the marks of a student with others. Follow the steps to create a simple clustered column chart.

Create Clustered Multiple Columns in Excel

Steps:

  • To begin with, click on cell B4 and drag your mouse while clicking, on cell D8.
  • Now, go to the Insert tab on the top of your screen.
  • Here, from the 2-D chart option, select the Clustered Column option.

Create Clustered Multiple Columns in Excel

  • After completing the previous step, Excel will plot a clustered chart for your dataset.

Read More: How to Sort Column Chart in Descending Order in Excel


Generate Graph with Bar Column Chart

In this section, we will explore a different type of column chart. This is called the Horizontal Bar Chart. The Bar chart is simple and effective for presenting data. Let us see how we can generate one.

Steps:

  • First of all, select your whole dataset either using mouse or keyboard shortcuts which I showed in the previous methods.
  • Now, select the Insert tab.
  • Then, from the Insert tab options, click on the Column Chart icon.
  • Here, choose the 2-D Bar option by clicking on it.

Generate a Graph with Bar Column Chart

  • Finally, you will get a 2-D bar chart representing your data.

Read More: How to Create a Comparison Column Chart in Excel


Format Columns in Graph

After creating charts in Excel, what you want next is to format them. This will make those charts more visually attractive and more readable. Excel gives us plenty of options to format the charts. Let us apply some chart formatting techniques.

Steps:

  • Firstly, select your chart and click two times on any of the columns that you want to format.
  • Now, navigate to the Format tab and select it.

Format Columns in Graph

  • By doing the previous step, the format ribbon will show up. Here you can customize your chart in many ways.
  • For this, click on the Shape Fill dropdown and pick a color of your choice. I have chosen orange here.

Format Columns in Graph

  • Consequently, you will now notice that the column you selected is now filled with the color of your choice.


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

I really hope that you understood the methods that I showed in this tutorial. Although the datasets that we used were short, you can take these methods and apply them to larger datasets of your own. Also, try to add formatting in a way that makes your data more visual. If you have any queries, please let me know in the comments.


Related Articles


<< Go Back To Column Chart in ExcelExcel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo