# How to Create Graphs in Excel with Multiple Columns (5 Methods)

Watch Video â€“ Create Graphs in Excel with Multiple Columns

## Method 1 – Create 2-D Graph with Multiple Columns in Excel

Ther is a sample dataset of monthly income, so, we have two variables in our dataset.

Steps:

• Click on cell B4.
• Press Ctrl+Shift+Down arrow.
• While pressing Ctrl+Shift, press the Right arrow. So, this will select the whole data table.

• Go to the Insert tab and click on the ChartÂ option.
• Click on the Stacked ColumnÂ option.

• A graph with multiple columns is returned.

## Method 2 – Insert 3-D Graph in Excel with Multiple Columns

The dataset shows the changed salary of 4 people from January to February.

Steps:

• Select the dataset as before or use the mouse to select the dataset.
• Navigate to the Insert tab and select the 3D Column as below.

• This will insert a 3D column chart beside the dataset.

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

## Method 3 – Create Graph with Clustered Multiple Columns in Excel

The sample dataset contains the exam marks of four students for Physics and Math. The clustered column chart is suitable where there are more than two variables.

Steps:

• Click on cell B4 and drag the mouse to cell D8.
• Go to the Insert tab on the ribbon.
• From the 2-D chart option, select the Clustered ColumnÂ option.

• Excel will plot a clustered chart.

## Method 4 – Generate Graph with Bar Column Chart

Steps:

• Select your whole dataset either using mouse or keyboard shortcuts.
• Select the InsertÂ tab.
• From the Insert tab options, click on the Column ChartÂ icon.
• Choose the 2-D Bar option.

• A 2-D bar chart will be returned.

## Method 5 – Format Columns in Graph

Steps:

• Select thechart and click two times on any of the columns to be formatted.
• Navigate to the Format tab and select it.

• The format ribbon appear.
• Click on the Shape Fill drop-down and pick a color – orange is selected in this example.

• The selected column is now orange.

## Related Articles

<< Go Back To Column Chart in Excel |Â Excel Charts |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF