Excel Area Chart (2-D & 3-D Formats)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we have shown you the step-by-step process to create an Excel Area Chart. We have discussed the Stacked Area Chart and 100% Stacked Area Chart. We have explored the steps to create Excel Area Chart in 2-D and 3-D formats.

Excel Area Charts are very useful for data comparison and visualizing trends. These charts are flexible, easy to understand and customizable.

Overall, Excel Area Charts can help us in data analysis, presentation and making decisions depending on data points.

Excel Area Chart


Download Practice Workbook

You can download this practice workbook while going through the article.


How to Create an Excel Area Chart

We will use the following dataset to create a basic Excel Area Chart.

Dataset to Create Excel Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select an Area Chart.

Select Area Chart

  • You will see the Area Chart in your worksheet.

Area Chart


Excel Area Charts: 2-D Area Charts

1. Stacked 2-D Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select Stacked 2-D Area Chart.

Select Stacked 2-D Area Chart

  • You will see the Stacked 2-D Area Chart in your worksheet.

Stacked 2-D Area Chart


2. 100% Stacked 2-D Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select 100% Stacked 2-D Area Chart.

Select 100% Stacked 2-D Area Chart

  • You will see the 100% Stacked 2-D Area Chart in your worksheet.

100% Stacked 2-D Area Chart


Excel Area Charts: 3-D Area Charts

1. Simple 3-D Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select 3-D Area Chart.

Select 3-D Area Chart

  • You will see the 3-D Area Chart in your worksheet.

3-D Area Chart


2. Stacked 3-D Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select Stacked 3-D Area Chart.

Select Stacked 3-D Area Chart

  • You will see the Stacked 3-D Area Chart in your worksheet.

Stacked 3-D Area Chart


3. 100% Stacked 3-D Area Chart

  • Select range B4:E10 >> go to the Insert tab >> select Area Chart from the Charts group >> select 100% Stacked 3-D Area Chart.

Select 100% Stacked 3-D Area Chart

  • You will see the 100% Stacked 3-D Area Chart in your worksheet.

100% Stacked 3-D Area Chart


Bring Excel Area Chart to Front

  • Create a 2-D Area Chart from the dataset.

Create 2-D Area Chart

  • Create a 3-D Area Chart from the dataset.

Create 3-D Area Chart

  • Now the 2-D Area Chart is below the 3-D Area Chart.
  • To bring it at front, right-click on the 2-D area chart >> select Bring to Front.

Right-click on 2-D Area Chart

  • You will see the 2-D Area Chart at the front of the 3-D Area Chart.

Bring 2-D Area Chart at Front


How to Change Order of Area Chart

  • Create a Stacked 2-D Area Chart.
  • The order of the chart is Mobile, Television, Laptop. You can customize this order.

Create Stacked 2-D Area Chart

  • Right-click on the chart >> Select Data.

Right-click on Stacked 2-D Area Chart

  • In the Select Data Source dialog box, select a Legend Entry >> use the Move Down button to change the order of that entry.

Change Order of the Chart

  • We have changed the order to Television, Laptop, Mobile.

Stacked 2-D Area Chart with Changed Order

Read More: How to Change Order of Excel Stacked Area Chart


Make Excel Area Chart Lines Smooth

  • Make an Area Chart from the dataset of range B4:C10.

Create an Area Chart from Dataset

  • Right-click on the chart >> Select Data.

Select Data Option

  • The Select Data Source dialog box will appear.
  • From there, click on Add.

Add Legend from Select Data Source Dialog Box

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

Series Name in Edit Series Pop-up

  • Select range E5:E10 of the Month column and click on the down arrow.

Select Range for Series Name

  • Click on the up arrow under the Series values header.

Series Values in Edit Series Pop-up

  • Select range F5:E10 of the Mobile column and click on the down arrow.

Select Range for Series Values

  • Press OK in the Edit Series pop-up.

Edit Series Pop-up

  • Press OK in the Select Data Source dialog box.

Select Data Source Dialog Box

  • You will see a new chart added to the old one.

Modified Area Chart

  • Now, right-click on the middle of the chart >> select Change Series Chart Type.

Change Series Chart Type

  • The Change Chart Type window will appear.
  • Go to All Charts >> click on Combo.
  • Choose the new chart under the Series Name header.
  • Change the Chart Type to Line and press OK.

Combining Line Chart with Area Chart

  • Now, right-click on the chart and select Format Data Series.

Format Data Series

  • The Format Data Series window will open on the right side of your worksheet.
  • Click on Series Option >> select the new chart.

Selecting the Line Chart

  • Select Fill & Line >> click on the Line option.
  • Keep the Color the same as the other chart (Blue).
  • Check the Smoothed Line option.

Format Line Chart

  • Now, look at the chart. You may see some gaps in between the Line Chart and the Area Chart.

Area Chart with Gaps

  • To get rid of these small gaps, increase the Width of the Line Chart.

Increase Width of Line Chart

  • Increase the Width of the Area Chart.

Increase Width of Area Chart

  • You will see the Area Chart with smooth lines.

Area Chart with Smooth Lines

Read More: How to Make Smooth Area Chart in Excel


Pros of Excel Area Chart

  • Excel Area Chart is a great way to display trends of products over a specified period of time.
  • It gives a clear insight of the pattern followed by each product.
  • It is a simple presentation and easy to understand.
  • It can handle both positive and negative values.

Cons of Excel Area Chart

  • Excel Area Chart may become difficult to analyze if there are a lot of data points.
  • It doesn’t normally work well with multiple data series.
  • Each line can imply more data than actually available, in comparison to Bar Chart or Column Chart.

Things to Remember

  • Users should have a basic understanding of an Area Chart.
  • The data should include only a few categories to avoid clutter in the plotted chart.
  • One should compare with each other concerning time.

Frequently Asked Questions

1. How many types of Area Charts are there in Excel?

There are three in-built types of Area Charts in Excel:

  • Area Chart
  • Stacked Area Chart
  • 100% Stacked Area Chart

2. Can I use Excel formulas in an Area Chart?

Area Charts mainly rely on numerical data from the worksheet. So, you can use formulas to perform calculations and generate the data that populates Excel Area Charts.

3. Can I combine an Area Chart with other chart types in Excel?

Yes, you can combine an Area Chart with other types of charts in Excel.


Conclusion

In this article, we have presented the process to create an Excel Area Chart. This article aims to enhance users’ efficiency and productivity when it comes to creating and manipulating Excel Area Charts. If you have any questions regarding this essay, don’t hesitate to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website, and unlock a great resource for Excel-related content.


Excel Area Chart: Knowledge Hub


<< Go Back To Excel ChartsLearn Excel

What is ExcelDemy?

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

Tags:

Md. Abu Sina Ibne Albaruni
Md. Abu Sina Ibne Albaruni

Md. Abu Sina Ibne Albaruni holds a BSc in Mechanical Engineering from Bangladesh University of Engineering and Technology. He is a dedicated employee of the ExcelDemy project. He has written quite a large number of articles for ExcelDemy. Besides, he has expertise in VBA. He efficiently automates Excel issues using VBA macros and actively engages in the ExcelDemy forum, offering valuable solutions for user interface challenges. His areas of interest in work and study span MATLAB, Machine Learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo