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

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.

Read More: Stacked Area Chart with Line in Excel

Download Practice Workbook

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

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.

Related Articles

• Proportional Area Chart Excel
• How to Shade an Area of a Graph in Excel
• Excel Area Chart X-axis Scale
• Excel Stacked Area Chart Change Order

<< Go Back To Excel Area Chart | Excel Charts | Learn Excel