How to Create an Excel Chart with Data from Different Columns (3 Methods)

To start, we’ve created a dataset called Training Session Dataset for the Year 2021. It features headers labeled as Name, Training Session (Hours), and Training Completed in Columns B, C, and D, respectively. We’ve populated the Training Completed column with values calculated from a total Training Session of 400 hours. Here’s what the dataset looks like.

selecting data in different columns for an excel chart


Method 1 – Using CTRL Key for Selecting Data:

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

  • Select Column B, and while holding the CTRL key, select Column D. This allows you to choose both columns simultaneously.
  • Go to the Insert tab and select the Insert Column or Bar Chart option.

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

  • Choose the 2-D Clustered Column figure.

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

  • The resulting chart will display the graphical representation of Training Completed for different individuals.

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


Method 2 – Utilizing Chart Design Option:

  • If you have non-adjacent columns, use the Chart Design option.

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

  • Add another column (e.g., Column E named Training Remaining) to your dataset.
  • Select the entire dataset, go to the Insert tab, and choose the Insert Column or Bar Chart option.

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

  • Select the 2-D Clustered Column option.

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

  • Click on the chart, go to the Chart Design tab, and choose Select Data.

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

  • In the Select Data Source window, deselect Training Session (Hours).
  • Click OK.

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

  • The chart showing Training Completed and Training Remaining for each person will be displayed.

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

  • Edit the chart title to Training Scenario.

 using chart design option

Read More: How to Select Data for a Chart in Excel


Method 3 – Using Data Source Dialogue Box:

 using select data source dialogue box

  • Create a blank chart (similar to Method 2) without selecting the dataset.
  • Click on the blank chart, then choose Chart Design and choose Select Data.

 selecting data source dialogue box

  • In the Select Data Source window, click 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 cells B5:B11 as the Series Name and C5:C11 as the Series Value.
  • 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. Add cells B5:B11 as the Series Name and E5:E11 as the Series Value.
  • Click OK.

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

  • The Select Data Source window will appear again.
  • Click Edit in the Horizontal (Category) Axis Labels bar.

selecting data source dialogue box

  • In the Axis Labels window, add B5:B11 as the axis label range (representing the horizontal axis).
  • Click OK.

selecting data source dialogue box

  • Click OK in the Select Data Source window.

selecting data source dialogue box

  • You’ll get the final chart.

selecting data source dialogue box

Read More: How to Expand Chart Data Range in Excel


Things to Remember

Remember that in the Edit Series window, you need to add column names in the Series Name bar and column values in the Series Values bar.


Download Practice Workbook

You can download the practice workbook from here:


 

Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
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