If you are looking for selecting data in different columns for an Excel chart, then you are in the right place. In our practical life, we often need to make charts based on various random columns. In this article, we’ll try to discuss selecting data in different columns for an Excel chart.
Download Practice Workbook
3 Ways of Selecting Data in Different Columns for an Excel Chart
Basically, there are a couple of methods by which we can make Excel charts with different columns. To do this, firstly, we have made a dataset named Dataset of Training Session for the Year 2021. It has headers marked as Name, Training Session (Hours), and Training Completed in Columns B, C, and D respectively. We have set the values of Training Completed by taking a total Training Session as 400 hours. The dataset is like this.
Let’s see various methods regarding this.
1. Using CTRL Key for Selecting Data in Different Columns for an Excel Chart
One of the simplest methods is to use the CTRL key to select different columns while making charts. We need to select columns in the following dataset using CTRL Key.
Firstly, select Column B, and holding the CTRL key select Column D. This CTRL key helps to select these two columns at a time.
Secondly, go to Insert > select the Insert Column or Bar Chart option marked below.
Thirdly, select the 2-D Clustered Column figure.
Eventually, the chart will be like this where we can see the graphical representation of Training Completed for different persons.
In the case of Non-adjacent columns to make a chart we can utilize the Chart Design option. To apply this method, firstly, we have added another Column E named Training Remaining in the previous dataset like this.
Secondly, select the whole dataset > go to the Insert tab > select the Insert Column or Bar Chart option shown below.
Thirdly, select the 2-D Clustered Column option like this.
As a result, we’ll get the chart like the picture marked below.
Fourthly, click on the chart > go to the Chart Design tab > select the Select Data option.
The Select Data Source window will appear.
Fifthly, deselect Training Session (Hours).
Sixthly, click OK.
Consequently, we’ll get our chart like this where Training Completed and Training Remaining for each person is displayed.
Seventhly, edit the Chart Title to Training Scenario.
- How to Create Graph from List of Dates in Excel (with Easy Steps)
- How to Expand Chart Data Range in Excel (5 Suitable Methods)
- Excel VBA: Get Source Data Range from a Chart (with Quick Steps)
- How to Change Chart Data Range in Excel (5 Quick Methods)
- How to Format Data Series in Excel (with Easy Steps)
3. Using Data Source Dialogue Box for Selecting Data in Different Columns for an Excel Chart
Additionally, we can use the Data Source Dialogue Box to make charts using non-adjacent columns. We’ll use the following dataset to make the chart.
Firstly, create a blank chart following the same procedure as Method 2. The only difference is we don’t need to select the dataset in this procedure.
Secondly, select the blank chart > click Chart Design > select Select Data.
A Select Data Source window will appear.
Thirdly, click on Add.
An Edit Series window will appear. Select the cells B5:B11 in the Series Name bar and C5:C11 in the Series Value bar.
Fourthly, click OK.
Again click Add in the Select Data Source window. Another Edit Series window will open. Add cells B5:B11 in the Series Name bar and E5:E11 in the Series Value bar.
Fifthly, click OK.
Consequently, the Select Data Source window will appear again.
Sixthly, click Edit in the Horizontal (Category) Axis Labels bar.
Seventhly, the Axis Labels window will appear.
Eighthly, add B5:B11 in the Axis label range bar. This mainly represents the horizontal axis of the bar. Then click OK.
Again click OK in the Select Data Source window.
Eventually, we’ll get the chart like this.
Things to Remember
In the Edit Series window, we have to add columns with names in the Series Name bar and columns with values in the Series Values bar.
By studying this article on how to select data in different columns for an Excel chart we can create any kind of Excel chart by using different columns. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.
- How to Plot Time over Multiple Days in Excel (With Easy Steps)
- How to Add Multiple Trendlines in Excel (With Quick Steps)
- Excel Chart by Month and Year (2 Suitable Examples)
- How to Create Excel Chart Using Data Range Based on Cell Value
- How to Group Data in Excel Chart (2 Suitable Methods)
- Use Scatter Chart in Excel to Find Relationships between Two Data Series
- [Solved]: Excel Graph Is Not Showing All Dates (with Easy Steps)