How to Select Multiple Columns in Excel for Graph (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

To create a chart, we need a minimum of two variables for two axes. That means we need two rows or columns in Excel. In this article, we will show how to select multiple columns in Excel of different conditions to create a graph with proper illustrations.

3 Methods to Select Multiple Columns for Graph in Excel

We are here to create a graph by selecting multiple columns in Excel. We have 3 columns in our dataset to create a graph based on different situations.

1. Select Multiple Adjacent Columns for Graph

In this section, we will create a graph by selecting multiple adjacent columns in Excel.

📌 Steps:

• Go to the sheet.
• Select all three columns of the dataset using the mouse of Range B4:D10.

We can also select the cells by keyboard shortcut. Enter Cell B4. Press Ctrl+Shift and then press the right arrow. Keep pressing the Ctrl+Shift and then click on the down arrow.

• Click on the Insert tab.
• Press the down arrow of the Insert Column or Bar Chart of the Chart group.
• Choose the Cluster Column of graph type.

• We can see a graph has been created.

This graph presents the Revenue and Cost for the specific months.

2. Select Non-Adjacent Columns for Graph

In this section, we will show how to create a graph by selecting multiple non-adjacent columns in Excel.

📌 Steps:

• Here, we first add a new column in the dataset. This column indicates the profit based on the difference between the revenue and cost.

• Now, select the Month, Revenue, and Profit columns

Those all are not adjacent.

• Again, go to the Insert tab.
• Go to the Clustered Column option as shown before.

• Have a look at the graph.

This graph shows the columns of Revenue and Profit against Month.

3. Select Multiple Columns for Graph from Data Source

In this section, we will create a graph by selecting multiple columns. Then, filter out unnecessary columns from the graph.

📌 Steps:

• We select all the columns from the dataset.

• After that, select the Insert tab.
• Again, choose the Clustered Column.

• Look at the graph.

There are three columns. But we want only to present the information of Cost and Profit in the graph.

• Now, double-click on the graph.
• The Chart Design tab is showing now.
• Click on the Select Data option from the Data group.

• The Select Data Source window appears now.

We can see all three columns are marked.

• We unmark the Revenue option.
• Then, press the OK button.

• Now, look at the graph again.

The revenue column has been removed from the graph.

Conclusion

In this article, we described 3 methods to create a graph by selecting multiple columns in Excel. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.

Related Articles

Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF