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.
1. Select Multiple Adjacent Columns for Graph
In this section, we will create a graph by selecting multiple adjacent columns in Excel.
- 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.
- 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.
- Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)
- Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)
- [Solved!] CTRL+END Shortcut Key Goes Too Far in Excel (6 Fixes)
- Select All Cells with Data in Excel (5 Easy Methods)
- How to Select Cells in Excel Using Keyboard (9 Ways)
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.
- 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.
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.
- How to Select Cells in Excel Without Dragging (7 Ideal Examples)
- How to Select Highlighted Cells in Excel (4 Easy Techniques)
- [Fixed!] Selected Cells Not Highlighted in Excel (8 Solutions)
- How to Select Large Data in Excel Without Dragging (5 Easy Ways)
- Select & Delete Blank Cells in Excel (3 Quick Ways)
- How to Go to the End of Excel Sheet (2 Quick Methods)