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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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.

Sample Data: Select Multiple Columns for Graph in Excel


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.

Select multiple columns to create a graph

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.

Read More: How to Select Multiple Cells in Excel without Mouse (9 Easy Methods)


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.

Add a new column in the dataset of Excel

  • 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.

Graph of non-adjacent cells

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

Read More: How to Select Column to End of Data in Excel (3 Easy Methods)


Similar Readings


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.

Graph customization of Excel

  • 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.

Remove unnecessary options from the data source of Excel graph

  • Now, look at the graph again.

Graph of filtered cells

The revenue column has been removed from the graph.

Read More: How to Select Data in Excel for Graph (5 Quick Ways)


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
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo