How to Insert Proportional Area Chart in Excel (4 Easy Steps)

Charts are useful tools that can be used for representing data in an Excel worksheet. We can also use Area Charts to display the data charts in a proportional way. This article is going to show how you can insert data in a Proportional Area Chart in Excel.

How to Insert Proportional Area Chart in Excel (With Easy Steps)

First, We have to take a dataset of 4 different items. Then, we will modify the data according to our requirements.

After that, we need to remodel the modified data so that we can insert that in an Area Chart.

Step 1: Dataset for Proportional Area Chart

We have taken a dataset of 4 different fields and their land areas. The purpose of this article is to present them in a 2-D Chart in square shapes.

Read More: How to Create an Area Chart in Excel

Step 2: Data Modification

As mentioned earlier, we are going to present the field area in square shapes. For that, we have to calculate the equivalent Arm Length of each square. For that, we will use the SQRT function.

So, Add another Row just below the dataset.

Then, write the following formula in C10 and Press Enter.

=SQRT(C5)

This SQRT() function finds the Square Root of a given number.

So, we get the Arm Length for Field A and which is 10.

Now, Hold and Drag the C10 cell rightwards to Copy the formula.

Thus, we have got Arm Length for each Field.

Step 3: Remodelling Data

We have to insert the Field Area in a 4-coordinated system. Already we have found the Arm Length which will be used as coordinates. Now these coordinates can be both positive and negative.

Add a new data table like the one given below.

As we have to create a square, the Arm Length has to be taken as both X Values and Y Values.

We have to take two X Values negative and the other two positive and also have to include 0.

So, we have taken -15, -10, 0, 12 and 13 sequentially.

All the squares are connected to point (0,0). Field A is extended from 0 to -10. And we assume that it’s in the 2nd Coordinate.

So, insert positive 10 in C11 and C12.

We want Field B to be in the 1st Coordinate.

So, write the Arm Length 12 in D12 and D13.

Similarly, we want Field C to be in the 4th Coordinate.

So, Write -13 in E12,E13 and E14.

And, Field D is to be placed in the 3rd Coordinate.

So, Write -15 in F12, F11 and F10.

And, we have remodeled the dataset.

Step 4: Creating Proportional Area Chart

Now, let’s insert this remodelled data in an Area Chart.

First, Select the data range (C9:F14).

Then, go to the Insert tab from the Insert Line or Area Chart section Select 2-D Area chart.

A chart like this will appear.

Now, we have to set the X Values.
So, place your mouse on the chart and Click right.
A window like this will appear.
Click on Select Data.

After that, Select the Edit option in the Horizontal (Catagory) Axis Labels section.

A new window Axis label range will appear.

Now, Select X Values range (B10:B14) and Press OK.

And, in the previous window, Press OK.

Your chart will still look the same. But don’t worry.

Double Press on any color.

And, this new window will appear.

Change the Series Options from Primary Axis to Secondary Axis.

And, again Change the Series Options from Secondary Axis to Primary Axis.

Thereby, your data will be plotted as a Proportional Area Chart.

Read More: Smooth Area Chart Excel

Practice Section

You can download the practice workbook where you can practice yourself.

Download Practice Workbook

You can download and practice this Workbook.

Proportional Area Chart.xlsx

Conclusion

We have shown you how to insert a proportional Area Chart using 4 data. If you have to compare more than 4 data this method will not be useful. We hope you find the content of this article useful. If there are further queries or suggestions, make sure you mention them in the comment section. Have a good day.