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

Get FREE Advanced Excel Exercises with Solutions!

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.

## 4 Steps for Inserting Proportional Area Chart in Excel

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 Circular Area Chart in Excel (With Detailed Steps)

### 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 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 Coordinate 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 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 remodelled the dataset.

Read More: How to Create Stacked Area Chart with Negative Values in Excel

### 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 colour. 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: How to Resize Chart Plot Area Using VBA in Excel

## Practice Section ## 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.

## Related Articles Sourav Kundu

Hi, I am Sourav Kundu. I live in Adabor, Dhaka. I graduated in Naval Architecture and Marine Engineering from BUET. I am really excited to be a part of SOFTEKO family. I want to develop my research skill and find innovative solutions for the given problems.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  