Selecting Data in Different Columns for an Excel Chart

Last updated: March 22, 2023
Get FREE Advanced Excel Exercises with Solutions!

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.

selecting data in different columns for an excel chart

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.

 selecting data in different columns for an excel chart, 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.

selecting data in different columns for an excel chart, using CTRL key

Thirdly, select the 2-D Clustered Column figure.

selecting data in different columns for an excel chart, using CTRL key

Eventually, the chart will be like this where we can see the graphical representation of Training Completed for different persons.

selecting data in different columns for an excel chart, using CTRL key

Read More: How to Select Data for a Chart in Excel (2 Ways)


2. Utilizing Chart Design Option

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.

selecting data in different columns for an excel chart, using chart design option

Secondly, select the whole dataset > go to the Insert tab > select the Insert Column or Bar Chart option shown below.

selecting data in different columns for an excel chart, using chart design option

Thirdly, select the 2-D Clustered Column option like this.

selecting data in different columns for an excel chart, using chart design option

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.

selecting data in different columns for an excel chart, using chart design option

The Select Data Source window will appear.
Fifthly, deselect Training Session (Hours).
Sixthly, click OK.

selecting data in different columns for an excel chart, using chart design option

Consequently, we’ll get our chart like this where Training Completed and Training Remaining for each person is displayed.

selecting data in different columns for an excel chart, using chart design option

Seventhly, edit the Chart Title to Training Scenario.

 using chart design option

Read More: Excel Chart Not Updating with New Data (2 Suitable Solutions)


Similar Readings


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.

 using select data source dialogue box

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.

 selecting data source dialogue box

A Select Data Source window will appear.
Thirdly, click on Add.

how to select data in different columns for an excel chart, using select data source dialogue box

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.

how to select data in different columns for an excel chart, using select data source dialogue box

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.

how to select data in different columns for an excel chart, using select data source dialogue box

Consequently, the Select Data Source window will appear again.
Sixthly, click Edit in the Horizontal (Category) Axis Labels bar.

selecting data source dialogue box

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.

selecting data source dialogue box

Again click OK in the Select Data Source window.

selecting data source dialogue box

Eventually, we’ll get the chart like this.

selecting data source dialogue box

Read More: How to Change Data Source in Excel Chart (3 Useful Examples)


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.


Conclusion

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.


Related Articles

Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo