How to Highlight When Line Drops or Peaks in Comparison Excel Chart?
Tags: highlightwhenlinedro
Published: 2021-08-21 04:13:55

---
title: How to Highlight When Line Drops or Peaks in Comparison Excel Chart?
published: true
date: 2021-08-12 17:02:31 UTC
tags: HighlightWhenLineDro
canonical_url: https://geekexcel.com/how-to-highlight-when-line-drops-or-peaks-in-comparison-excel-chart/
---

In this tutorial, we will guide you to know the step-by-step instructions to **Highlight When Line Drops Or Peaks In Comparison Excel Chart.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Insert Data

- Firstly, you need to **enter the data** in the Excel spreadsheet.
- For instance, you have to create the **sample Month data**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-Month-data.png)<figcaption>Sample Month Data</figcaption>

## Add Three Helper Columns

- Firstly, to make a **chart that shades the up and downs of the line** in comparison, you need **three helper columns**.
- Here, the **first helper column** will contain the **same values** as the first month, and you have to name it as **Month1 shade**.
- Then, in **Cell D2** , you have to write this **formula** and drag it down.

```
=B2
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Add-Month1-Shade.png)<figcaption>Add the Month1 Shade</figcaption>

- Now, in the **next column** , you need all the **UP values** , and it will be a **positive difference** between **Month2 and Month1 data**.
- After that, you have to use the formula in **E2** and **drag it down**.

```
=IF(C2>B2,C2-B2,"")
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Add-UP-column.png)<figcaption>Add UP column</figcaption>

- At last, you need a **DOWN column** that has **all the points** that are **less than Month1’s Data** and the formula in **F2**.

```
=IF(C2<B2,C2-B2,"")
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Add-DOWN-column.png)<figcaption>Add DOWN column</figcaption>

## Select the Day & Month1 Column & Insert a Stacked Area Chart

- In Sample Data, you need to **select the range A1:B8**.
- Then, you have to go to **insert** tab.
- Now, you need to click on the **Line and Area** chart and choose **Stacked Area Chart** under the chart section.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-stacked-line-chart-1024x380.png)<figcaption>Click in the Stacked Line chart</figcaption>

- At last, you will get the **stacked line chart** result.

![](https://geekexcel.com/wp-content/uploads/2021/08/Stacked-line-chart.png)<figcaption>Stacked Line chart</figcaption>

## Add other columns as data series to the chart

- You need to **right-click** on the **chart** and click on the **select data** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-select-data-4.png)<figcaption>Click on Select Data</figcaption>

- Then, in **legends and entries** , you have to click on the **add** button.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Add.png)<figcaption>Click on Add option</figcaption>

- Now, in the **series name** , you need to select **C1** (“Month2”).
- After that, in **series value** , you have to select **C2:C8**.

![](https://geekexcel.com/wp-content/uploads/2021/08/add-series-name-and-value-1024x739.png)<figcaption>Add Series name &amp; value</figcaption>

- Finally, you need to do **this for all the columns** , one by one.

![](https://geekexcel.com/wp-content/uploads/2021/08/for-all-columns.png)<figcaption>For All the columns</figcaption>

## Change the data series chart type of Month1 & Month2 to Line Chart

- You need to **right-click** on any **data series** and click on **Change Series Type**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-change-series-type.png)<figcaption>Click on Change Series Type</figcaption>

- Now, you have to **change the series type**  **of Month1** to **line chart** and **Month2 to Line With Markers**.

![](https://geekexcel.com/wp-content/uploads/2021/08/set-the-line-and-line-with-marker.png)<figcaption>Change the series type</figcaption>

- Finally, you will get the **changed series type** result.

![](https://geekexcel.com/wp-content/uploads/2021/08/Fianl-result.png)<figcaption>Final result</figcaption>

## Change the areas on the chart

- You need to **change the color** of the areas on the chart.
- Then, you have to **select the big bottom** area of the chart.
- Now, you need to go to **formatting** and in **Fill** option, you have to Select **No Fill**.
- After that, you have to do the **same for the border section** of the chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-No-fill-option-1-1024x463.png)<figcaption>Click on the No fill option</figcaption>

- You need to select the **Down Series** and go to **fill** and change the **color to red**.
- Then, you have to select the **UP series** and **change its color to green** and **increase the transparency** of the colors a little bit.
- Now, you need to **remove the grid lines**.
- After that, you have to go to **formatting of the Month1 series** and select **no line**.
- You need to click on the **Plus (+) sign** of the chart and **checked the legends**.
- Finally, after doing all the **above steps** , you will receive **final output** as given below.

![](https://geekexcel.com/wp-content/uploads/2021/08/Final-output-for-all-inputs-1024x783.png)<figcaption>Final results</figcaption>

## Wind-Up

In this tutorial, we guided you to learn the steps to **Highlight When a Line Drops Or Peaks In a Comparison Excel Chart.** I hope it was explanatory and useful. If you have any doubts regarding Excel Formula, Functions, Charts, or VBA, then leave your **feedback** in the comment section below. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

**Keep Reading:**

- **[Use Excel AREAS Function in Office 365 In Easy Ways!!](https://geekexcel.com/use-areas-function-in-microsoft-excel-365-in-easy-ways/)**
- **[Create a Year Over Year Comparison Bar Chart in Excel](https://geekexcel.com/how-to-create-a-year-over-year-comparison-bar-chart-in-excel/)**
- **[How to get a comparison product chart in Excel 365?](https://geekexcel.com/how-to-get-a-comparison-product-chart-in-excel-365/)**
- **[How to Create a Column Chart With Percentage Change in Excel?](https://geekexcel.com/how-to-create-a-column-chart-with-percentage-change-in-excel/)**
- **[Excel Formulas to Get the Last Line in a Cell ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-get-the-last-line-in-a-cell/)**