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 are 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

**Download Practice Workbook**

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

**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 of 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.

**Steps to Make a Bar Graph in Excel with 4 Variables**

In this article, we will show all steps to making a **Bar **graph in Excel with **4** variables. We have a data set that contains information on the showroom of 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 Change Bar Chart Width Based on Data in Excel (with Easy Steps)**

**📌****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 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 name has changed accordingly.

**Read More:** **Reverse Legend Order of Stacked Bar Chart in Excel (With Quick Steps)**

**📌****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 in Excel with 2 Variables (3 Easy Ways)**

**Similar Readings**

**How to Create Stacked and Clustered Bar Chart in Excel (with Easy Steps)****How to Make a Grouped Bar Chart in Excel (With Easy Steps)****What is the Difference Between Bar Graph and Histogram?****How to Combine Two Bar Graphs in Excel (5 Ways)****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:** **Excel Bar Graph Color with Conditional Formatting (3 Suitable Examples)**

**📌****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 choose the green color from there.

We can see the bar color has changed successfully.

**Read More:** **How to Show Difference Between Two Series in Excel Bar Chart (2 Ways)**

**💬 ****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 want to show the change of overtime the
**Line**graph is better than the**Bar**chart.

**Conclusion**

In this article, we 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. Please have a look at our website **Exceldemy.com** and give your suggestions in the comment box.

**Related Articles**

**How to Make a Double Bar Graph in Excel (with Easy Steps)****How to Show Variance in Excel Bar Chart (with Easy Steps)****Excel Chart Bar Width Too Thin (2 Quick Solutions)****How to Make a Diverging Stacked Bar Chart in Excel (with Easy Steps)****Plot Stacked Bar Chart from Excel Pivot Table (2 Examples)****How to Add Vertical Line to Excel Bar Chart (3 Quick Ways)**