# How to Make Smooth Area Chart in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Excel is a very useful tool for plotting different kinds of charts. Excel offers various options to format the plotted charts to make it look more attractive. While making a smooth line chart is an easy task in Excel, one might find it difficult to make a smooth area chart in Excel. In this article, we will walk you through five steps to make a smooth area chart in Excel.

## How to Make Smooth Area Chart in Excel (With Easy Steps)

In this article, we will demonstrate five easy steps to make a smooth area chart in Excel. We will use the following dataset for this purpose.

### Step 1: Insert an Area Chart

In the first step, we will create an area chart using the dataset.

• First of all, select all the data from the Months and SalesÂ columns.
• Then click on the Insert tab and go to,

Insert â†’ Charts â†’ Insert Line or Area Chart â†’ Area

• Hence, the area chart will be created.

Read More: Excel Area Chart Data Label Position

### Step 2: Duplicate Data Series

In this step, we need to duplicate the data series to add a new chart to make a smooth area chart in Excel.

• First, select both Months and SalesÂ columns.
• Then press the right button of your mouse and click on Copy.

• After that, paste it into your preferred cells.

### Step 3: Add New Chart

Now we will add a new chart using the duplicated data series.

• First, right-click on the chart and click on Select Data.

• As a result, the Select Data Source dialog box will appear.
• From the dialog box, select Add.

• The Edit Series pop-up will open. Click on the arrow under the Series name.

• Then select the Months column and click on the arrow.

• Similarly, click on the arrow under Series values.

• Then select the Sales column and click on the arrow.

• After that, press Enter twice to get the new chart added to the old one.

Read More: Excel Stacked Area Chart Negative Values

### Step 4: Change Chart Type

In this step, we will change the type of the newly added chart.

• First of all, right-click on the chart and select Change Series Chart Type.

• The Change Chart Type window will pop up.
• In the window, go to the All Charts tab and click on Combo.
• Then choose the new chart under Series Name.
• Next, change the chart type to Line from Area.
• After that, click OK.

### Step 5: Check Smoothed Line Option

In the final step, we will smooth out the line option to make a smooth area chart in Excel.

• First, right-click on the Line chart and click on Format Data Series.

• As a result, the Format Data Series panel will open on the right side of the Excel sheet.
• In the panel, click on Fill & Line from the Series Options.
• Then check the box of the Smoothed lineÂ option.
• Finally, change the color to the same as the Area chart.

• Now, if you look at the chart, you might see small gaps between the Line and Area chart.

• To get rid of the small gaps, increase the Width of both the Line and Area chart.

• Consequently, you will have your desired smooth area chart in your Excel sheet.

Notes
• Create both the Line and Area chart in the same color.
• If there are small gaps between the Line and Area chart, increase the width of both charts.

Read More: Stacked Area Chart with Line in Excel

## Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know five easy steps to make a smooth area chart in Excel. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF