The Bar Graph is a type of graph to represents data in a specific way. There are more options to represent data through different graphs. Usually, there are two variables present in a bar graph. But in this article, we will show how to make a bar graph in Excel with 4 variables in detail.

**Table of Contents**hide

**What Is Bar Graph?**

A** Bar Graph** is a graphical representation of data with rectangular bars. The length of each bar represents the value or is proportional to the value of the variables. It is also called **Bar Chart**.

This is a sample bar graph, showing the revenue for different months

Some common characteristics of the **Bar Graph** are-

- All rectangular bars are of equal width and space.
- We can draw rectangular bars horizontally or vertically.
- Rectangular bars must be in the same base.
- The height or length of the bars indicates the value of the data presented.

**How to Make a Bar Graph in Excel with 4 Variables: With Easy Steps**

This article will show all the steps to making a **Bar **graph in Excel with **4** variables. We have a data set that contains information on the showroomâ€™s sales, profit, cost, and profit percentage each week. We will show all these variables in the bar graphs at the same time.

**ðŸ“Œ****Step 1: Insert Data for Bar Graph**

In the** 1st** step, we will insert data to form the bar graph. First, we will insert data for the **Week **and the **Sales **columns.

- Select
**Range B5:C9**. - Go to the
**InsertÂ**tab. - Choose the
**2-D Bar**option from the**Insert Column or Bar Chart**.

- Look at the dataset.

A bar chart has formed already.

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

**ðŸ“Œ****Step 2: ****Customize Legends in Bar Graph**

In this section, we will customize the Legends of the graph.

- Keep the cursor on the graph.
- Now, press the right button of the mouse.
- Click on the
**Select Data**from the**Context Menu**.

- The
**Select Data Source**window appears. - We can see that the data is named
**Series1**. Need to change the name here. - Select
**Series1**and then click on the**EditÂ**option.

- In the
**Series name**box choose**Cell C4**, which will set the legend of the shown graph.

- Finally, press
**OK**.

We can see that the name has changed accordingly.

**Read More:** Reverse Legend Order of Stacked Bar Chart in Excel

**ðŸ“Œ****Step 3: Add New Variables**

As we want to make a graph of **4** variables, we need to add **3** more variables to this graph.

- Click on the
**Add**button of the**Select Data SourceÂ**window.

- The
**Edit Series**window appears. - In the
**Series name**box choose**Cell D4.**After that choose the corresponding value column in the**Series values**box.

- Then, press
**OK**.

We can see **4** variables are shown in the window.

- Look at the graph now.

**4** bars are shown for each week of different colure.

**Read More:Â **How to Make a Bar Graph with Multiple Variables in Excel

**ðŸ“Œ****Step 4: ****Customize Graph Elements**

In this section, we will customize different elements of the graph to get a clear idea of the graph on the first look.

- Click on the graph.
- We can see a plus sign named
**Chart Elements**. - Click on there.
- Now, check the required elements from the list.

We want to customize the chart title, and axis title and show the legends.

- Give names to the chart and the axes.

Axes title, chart title, and legends are shown here clearly.

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

**ðŸ“Œ****Step 5: Edit and Format Data Series of Bar Graph**

In this step, we will edit the bars of the graph. Like we can change the color.

- Click on any bar of the graph.
- Double-click the bar.
- The
**Format Data Series**window appears on the right side. - Go to the
**ColorÂ**option.

- We chose the green color from there.

We can see the bar color has changed successfully.

**Read More:** How to Make a Bar Graph Comparing Two Sets of Data in Excel

**ðŸ’¬ ****Things to Remember**

In some cases, we should not use the **Bar **graph.

- When we want to show properties bar chart is not suitable rather than a
**PieÂ**chart. - When we want to show the change of overtime the
**Line**graph is better than the**BarÂ**chart.

**Download Practice Workbook**

Download the following practice workbook to exercise while you are reading this article.

**Conclusion**

In this article, we see the full process of how to make a bar graph in Excel with variables. We explained all the steps in detail with images. I hope this will satisfy your needs.

**Related Articles**

- How to Make a Percentage Bar Graph 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