If you are looking for ways to show the difference between two series with the help of a Bar chart in Excel, then this article is for you. So, let’s get started with our main article.

**Table of Contents**Expand

## Excel Bar Chart to Show Difference Between Two Series: 2 Ways

Here, we have a list of products including their selling prices with the cost prices of a company. For the two different series of selling prices and cost prices, we will show their differences with the help of a bar chart. Using the following two methods we will try to indicate the differences in actual values format and percentage format.

__Method-01__: Show Difference with Actual Values Between Two Series in Excel Bar Chart

In this section, we will manifest the differences between the selling prices and the cost prices with their actual values in a bar chart. To do this we have added some extra columns like ** Difference**,

**,**

*Base Difference***, and**

*Positive***.**

*Negative*__Step-01__: Using Formulas to Calculate Some Values for Bar Chart

➤ Type the following formula in cell **E4**.

`=C4-D4`

Here, **C4 **is the *Selling Price *value, and **D4 **is the value of the *Cost Price*.

➤ Press **ENTER **and drag down the **Fill Handle **tool.

Then, we will get the differences between the selling prices and cost prices; the values within the brackets represent the negative values.

➤ For determining the minimum value between the selling price and the cost price to have the base difference between them, we will use the following formula.

`=MIN(C4,D4)`

Here, the **MIN **function will define the minimum value between the selling and cost prices.

➤ Use the **AutoFill** feature of Excel.

Finally, we have the base differences between the selling prices and the cost prices.

Now, we will separate the differences between the two prices according to their positive values and negative values.

➤ For extracting the positive values use the following formula in cell **G4**.

`=IF(E4>0,E4,"")`

When the value in cell **E4 **is positive then the **IF **function will return this positive value otherwise a blank.

➤ Press **ENTER **and drag down the **Fill Handle **tool.

After that, you will get the positive differences in the **Positive **column.

➤ For extracting the negative values use the following formula in cell **H4**.

`=IF(E4<0,ABS(E4),"")`

Here, **E4 **is the difference between the prices.

**ABS(E4) →**The**ABS**function will return the absolute value of the number in cell**E4**neglecting its sign.**Output → 2327****IF(E4<0,ABS(E4),””) →**becomes**IF(E4<0,2327,””) → IF**will return**2327**, when**E4<0**otherwise a blank.**Output → Blank**

➤ Use the **AutoFill** feature of Excel.

Finally, we are having the two negative values without their symbols in the **Negative **column.

__Step-02__: Plotting Differences in Bar Chart

Now, we will plot the differences between the prices with their actual values.

➤ Select the columns **Product**, **Selling Price**, and **Cost Price **first, and then for the rest of the non-adjacent columns **Base Difference**, **Positive**, and **Negative** select them by pressing **CTRL**.

➤ Now, go to the **Insert **Tab >> **All Chart Types **Option.

After that, the **Insert Chart **dialog box will appear.

➤ Go to the **All Charts **Tab >> **Bar **>> **Stacked Bar **>> select your desired type of **Stacked Bar **chart >> press **OK**.

Then, the bar chart will appear.

➤ Select any series from the combination of the series of the stacked bar chart and then **Right-Click **here.

➤ Choose the option **Change Series Chart Type**.

Afterward, the **Change Chart Type **wizard will open up.

➤ Change the **Chart Type **from **Stacked Bar **to **Clustered Bar **and check on the **Secondary Axis **option for the two series ** Selling Price **and

**.**

*Cost Price*➤ Press

**OK**.

After that, we will get the following appearance of the bar chart.

Moreover, you can name the chart title as ** Difference Between Selling Price and Cost Price**.

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

__Method-02__: Show Difference Between Two Series with Percentage in Excel Bar Chart

In this method, we will try to show the percentage differences between the two series of prices in a bar chart.

__Step-01__: Using Formulas to Calculate Some Values for Bar Chart

➤ Type the following formula in cell **E4**.

`=C4-D4`

Here, **C4 **is the *Selling Price *value, and **D4 **is the value of the *Cost Price*.

➤ Use the **AutoFill **feature of Excel.

In this way, you will get the differences between the *Selling Price *values and *Cost Price *values.

Now, we will separate the differences between the two prices according to their positive values and negative values.

➤ For extracting the positive values use the following formula in cell **F4**.

`=IF(E4>0,E4,"")`

When the value in cell **E4 **is positive **IF **will return this positive value otherwise a blank.

➤ Drag down the **Fill Handle **tool.

In this way, you will have positive differences in the **Positive **column.

➤ For extracting the negative values use the following formula in cell **G4**.

`=IF(E4<0,ABS(E4),"")`

Here, **E4 **is the difference between the prices.

**ABS(E4) →**Here, the**ABS**function will return the absolute value of the number in cell**E4**neglecting its sign.**Output → 2327****IF(E4<0,ABS(E4),””) →**becomes**IF(E4<0,2327,””) → IF**will return**2327**, when**E4<0**otherwise a blank.**Output → Blank**

➤ Drag down the **Fill Handle **tool.

Eventually, we will have the two negative values without their symbols in the **Negative **column.

➤ To gain the percentages of the differences with respect to the cost prices of the products apply the following formula in cell **H4**.

`=E4/D4`

Here, **D4 **is the **Cost Price **and **E4 **is the difference between the prices.

➤ To gain the percentages for the rest cells use the **AutoFill **feature of Excel.

Eventually, we will have percentage differences in the prices with respect to the cost prices.

__Step-02__: Mapping Values with Error Bars in Bar Chart

Here, we will plot the percentage differences in the bar chart.

➤ Select the columns **Product**, **Selling Price**, and **Cost Price** and then go to the **Insert **Tab >> **All Chart Types **Option.

After that, the **Insert Chart **dialog box will appear.

➤ Go to the **All Charts **Tab >> **Bar **>> **Clustered Bar **>> select your desired type of **Clustered Bar **chart >> press **OK**.

➤ Choose the **Cost Price **series of the chart and then click on the **Chart Elements **icon.

After that, different options will appear.

➤ Click on the arrow symbol beside the **Error Bars **option and choose the option **More Options**.

On the right pane, the **Format Error Bars **wizard will open up.

➤ Under the **Horizontal Error Bar **options, choose the **Both **option from ** Direction**, and the

**Cap**option from

**End Style**.

➤ Click on the

**Custom**option and then select the

**Specify Value**option.

Afterward, the **Custom Error Bars **dialog box will open up.

➤ Select the positive differences in the **Positive Error Value **box and then the negative differences in the **Negative Error Value **box.

➤ Press **OK**.

In this way, you will get the error bars in the series of the cost prices.

__Step-03__: Modifying Data Labels

➤To show the percentages click on the **Chart Elements **option and then check the **Data Labels **option.

➤ Select the data labels of the **Cost Price **series and then choose the **Format Data Labels **option.

In this way, you will have the **Format Data Labels **dialog box in the right pane.

➤ Within the **Label Options **choose the **Outside End **option as the **Label Position**, check on the **Show Leader Lines **option, and the **Value From Cells **option.

Afterward, the **Data Label Range **dialog box will appear.

➤ Choose the range of the percentages in the **Select Data Label Range **box and press **OK**.

Now, select the data labels of the selling price series.

➤ Then, uncheck the **Value **option.

In this way, you will get the following bar chart with the percentage differences between the prices.

In addition, you can name the chart title as ** Percentage Difference**.

**Read More:** How to Show Number and Percentage in Excel Bar Chart

## Practice Section

For doing practice by yourself we have provided a** Practice** section like below in each sheet on the right side. Please do it by yourself.

**Download Practice Workbook**

## Conclusion

In this article, we tried to cover the steps to show the difference between the two series with a bar chart in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

**Related Articles**

- How to Make a Bar Graph with Multiple Variables in Excel
- How to Make a Bar Graph in Excel with 2 Variables
- How to Make a Bar Graph in Excel with 3 Variables
- How to Make a Bar Graph in Excel with 4 Variables
- How to Make a Percentage Bar Graph in Excel
- 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**