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:

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.

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.

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

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

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

• This is the output.

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

Add one more variable to the Bar Chart. Here, MacBook Pro 16.

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

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

• In Series Value enter E6:E12.

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

• Click OK.

• Click OK.

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

Step 4 – Adding and Editing the Axis Titles

Add Axis Titles to the Bar Graph.

• Select the chart.
• Click Chart Elements.
• Check 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.

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.

This is the output.

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

Download Practice Workbook

Download the practice workbook here.

Related Articles

• How to Make a Bar Graph Comparing Two Sets of Data in Excel
• How to Show Number and Percentage in Excel Bar Chart
• How to Show Difference Between Two Series in Excel Bar Chart
• Excel Bar Chart Side by Side with Secondary Axis
• How to Sort Bar Chart Without Sorting Data in Excel
• How to Change Bar Chart Width Based on Data in Excel

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