How to Create a Bar Graph with Multiple Variables in Excel – 5 Steps

The dataset below showcases the Sales Quantity of three different laptop models over different weeks.

To compare Sales Quantity, use a Bar Chart:

How to Make a Bar graph with Multiple Variables in Excel Dataset


Step 1- Inserting a Bar Graph with Multiple Variables in Excel

Compare MacBook Air M1 and Dell XPS 13.

  • Select B6:D12.

B6 is the first cell of the column Week and D12 is the last cell of the column Dell XPS 13.

  • Go to the Insert tab.
  • Select Insert Column or Bar Chart.
  • Click Clustered Bar to insert a Bar Graph.

Insert a Bar Graph with Multiple Variables in Excel

Read More: How to Make a Percentage Bar Graph in Excel


Step 2 -Editing Legends in the Bar Graph

  • Right-click the chart.
  • Click Select Data.

Edit Legends

  • In the Select Data Source box, select Series 1 in Legend Entries (Series).
  • Click Edit.

Edit Legends

  • In Series name enter C5 (MacBook Air M1).
  • Click OK.

Edit Legends

  • Change Series 2 to Dell XPS 13.
  • Click OK.

Edit Legends

  • This is the output.Edit Legends

Step 3 – Adding Another Variable in the Bar Graph with Multiple Variables

Add one more variable: MacBook Pro 16.

  • Right-click the chart to open Select Data Source.
  • Click Add in Legend Entries (Series).

Add Another Variable in a Bar Graph with Multiple Variables in Excel

  • In Series name enter E5 (Macbook Pro 16).

Add Another Variable in a Bar Graph with Multiple Variables in Excel

  • In Series Value enter E6:E12.

E6 and E12 are the first and last cells of the MacBook Pro 16 column.

  • Click OK.

Add Another Variable in a Bar Graph with Multiple Variables in Excel

  • Click OK.

Add Another Variable in a Bar Graph with Multiple Variables in Excel

Read More: How to Make a Bar Graph in Excel with 2 Variables


Step 4 – Adding and Editing the Axis Titles

  • Select the chart.
  • Click Chart Elements.
  • Check Axis Titles.

Add Axis Titles

  • Double-click the Axis Titles to edit the text.
  • Change the X-axis title to Sales Quantity and the Y-axis title to Week.

Add Axis Titles

Read More: How to Make a Bar Graph in Excel with 3 Variables


Step 5 – Formatting the Data Series in the Excel Bar Graph

  • Double-click the bar MacBook Pro 16.
  • In the Format Data Series, select Fill.
  • Select Green in Color.

Format Data Series in Bar Graph with Multiple Variables in Excel

This is the output.

How to Make a Bar Graph with Multiple Variables in Excel

Read More: How to Make a Bar Graph in Excel with 4 Variables


Download Practice Workbook

Download the practice workbook here.


Related Articles


<< Go Back to Excel Bar Chart | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sowmik Chowdhury
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo