Selecting Data in Different Columns for an Excel Chart

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.


Selecting Data in Different Columns for an Excel Chart: 3 Useful Ways

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


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: How to Select Data for a Chart in Excel


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 Expand Chart Data Range in Excel


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.


Download Practice Workbook


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.


Related Articles


<< Go Back to Data for Excel ChartsExcel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo