How to Add Shade to Curve Line in Excel Chart 365?
Tags: addshadetoacurveline
Published: 2021-08-17 03:43:29

---
title: How to Add Shade to Curve Line in Excel Chart 365?
published: true
date: 2021-08-11 16:36:40 UTC
tags: AddShadeToaCurveLine
canonical_url: https://geekexcel.com/how-to-add-shade-to-curve-line-in-excel-chart-365/
---

Have you ever tried to **Add Shade To a Curve Line In Excel Chart 365?** Here we will show the simple steps to solve this problem. Let’s dive into this article! 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)**

## Create Shaded Line Chart

- You need to **enter the data** in the Excel spreadsheet.
- For instance, we have created **sample book count details**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Total-Book-Count.png)<figcaption>Total Book Count</figcaption>

- Then, you have to **select the data** in Excel worksheet.
- Now, you need to go to the **Insert tab**.
- After that, you have to click on the **Line Charts** under the **Chart** section.

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

## Add Helper Column to Data

- Firstly, to **add a shaded area to this line chart** , you need to create a **helping column** that has the **exact same value** as the **original series** has.
- Now, you have to use the **formula =B2** and **dragged it down** to get the **same values**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Create-Shaded-Area.png)<figcaption>Create Shaded Area</figcaption>

## Add Shaded Area Series

- You need to **right-click** on the **chart** and click on **Select Data**.

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

- Then, you have to click on **add series** and **select range C2:C6** as **series value** and hit **OK**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Range-1024x404.png)<figcaption>Click on the range</figcaption>

- Now, you will not see any **new curve** , but it is there.
- Finally, the **new series** covers the **original series** and that is why you can only see **one series**.

## Change Shaded Area Chart Type to Area Chart

- You have to **right-click** on the **series curve** and click on the **Change Series Chart Type**.

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

- Now, you need to **change the Shaded Area Series** to **Area Chart Type**.
- For that, you have to click on **combo** option and then in the **shaded area** you have to click on **area chart type**.

![](https://geekexcel.com/wp-content/uploads/2021/08/select-area-chart-type.png)

- Finally, you will receive the **area chart type** result.

![](https://geekexcel.com/wp-content/uploads/2021/08/Final-area-chart-type-1024x659.png)<figcaption>Area Chart Type</figcaption>

## Change the Formatting of Shaded Area to Gradient

- You need to **right-click** on the **shaded area** and click on the **format data series**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-format-data-series-1-1024x656.png)<figcaption>Click on format data series</figcaption>

- Then, from **fill,** you have to select **gradient fill.**
- Now, from the **Directions** , you need to choose **Linear Down**.
- After that, you have to **choose the colors** you want to use.
- Finally, you will receive the result as given below.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-color-1024x605.png)<figcaption>Select type and color</figcaption>

## Set the transparency of gradient to 50%

To make this **chart even cooler** , you need to set the **transparency of gradient colors** to your need and made it **50%**.

![](https://geekexcel.com/wp-content/uploads/2021/08/set-transparency-1024x610.png)<figcaption>Set transparency to 50%</figcaption>

## Format other components to suit your requirements

- Firstly, the shade to the curve is added, and the chart is almost ready, but you may want to make it even better to suit your requirements.
- Then, you have to **remove the components** from the **chart** that you don’t need.

![](https://geekexcel.com/wp-content/uploads/2021/08/remove-the-title-1024x635.png)<figcaption>Remove the components</figcaption>

- Now, you need to **format the line** and **markers** on the curve.
- Finally, you have to **change the background color** if you need it.

## Wrap-Up

From this tutorial, you can get some clarification to **Add Shade To a Curve Line In Excel Chart 365**. If you have any other **ideas** or **question** , do share with us here in the **comment’s** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

Read Also:

- **[Creating Quarterly Sales Chart by Clustered Region in Excel 365!!](https://geekexcel.com/creating-quarterly-sales-chart-by-clustered-region-in-excel-365/)**
- **[Charts with floating up-down bars in Excel 365 – Easy Tricks!!](https://geekexcel.com/charts-with-floating-up-down-bars-in-excel-365-easy-tricks/)**
- **[Excel Formulas to Find the First Column Number in a Range ~ Easily!!](https://geekexcel.com/excel-formulas-to-find-the-first-column-number-in-a-range/)**
- **[Excel Formulas to Find First Match between Two Ranges ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-find-first-match-between-two-ranges/)**
- **[Formulas to Define Range Based on Cell Value ~ Quickly!!](https://geekexcel.com/excel-formulas-to-define-range-based-on-cell-value/)**