How to Create Radar Chart and Fill Area in Excel (2 Suitable Ways)

While working in Microsoft Excel sometimes we need to fill the area of the radar chart to make it more lucrative. But it might seem difficult to you. Today in this article, I am sharing with you how to create a radar chart with fill area in Excel. Stay tuned!


Download Practice Workbook

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


2 Simple Methods to Create Radar Chart with Fill Area in Excel

In the following, I have described 2 simple and easy methods to fill the area of a radar chart in Excel.

Suppose we have a dataset of Product A, Product B, and Product C month-wise sales. Now, we will plot a radar chart using the data table and then fill different areas of the radar chart using some quick tricks.


1. Format Data Series Feature for Radar Chart with Fill Area

You can simply use the format data series feature of Excel to fill the selected portion of the chart with the desired color. With multiple line color, transparency, and width option, you can fill a specified area of the chart. Follow the instructions below-

Step 1:

  • First, let’s start with creating a chart. To do so, select the whole dataset and click “Recommended Charts” from the “Insert” option.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • Second, from the “Insert Chart” window choose “Radar” and your desired chart.
  • Hence, press OK.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • In summary, you will get a radar chart created in your worksheet. Without wasting time let’s start filling its multiple areas with the desired color.

Step 2:

  • Just select any data point from the chart and right-click the mouse button to get multiple options. From the options, press “Format Data Series”.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • Now, from the right pane, choose your desired “Color” and change the “Width” to 20.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • Thereafter, coming back to the worksheet you will see the chart ring is filled with your choice of color and with a filled area in it.

Step 3:

  • Now, we will edit the other areas of the chart. To do that, right-click and choose “Select Data” from the appeared options.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • From the popped-up “Select Data Source” window change the position of the “Sales of Product B” to downwards.

  • Similarly, change the “Sales of Product A” position to downwards and hit OK.

Use of Format Data Series Feature to Fill Area of Radar Chart

  • Finally, you will see the other rings appearing inside the chart. Thus you can fill the area of the radar chart in Excel. Simple isn’t it?

excel radar chart fill area

Read More: Excel Area Chart Data Label & Position


2. Insertion of Filled Radar Chart in Excel

In some situations, you might want to fill all the areas of a radar chart. Well, you can do that too by creating a filled radar chart in Excel. Go through the steps below-

Steps:

  • To start with, select the whole dataset and choose a “Filled Radar Chart” from the “Insert” option.

Insertion of Filled Radar Chart to Create Filled Radar Chart

  • Therefore, you will get the filled chart in your workbook.
  • Now, select any points of the dataset and right-click to get multiple options.
  • From the options choose “Select Data”.

Insertion of Filled Radar Chart to Create Filled Radar Chart

  • Hence, from the appeared window rearrange entries just like the previous method and press OK.

  • In conclusion, you will get a radar chart with filled area in Excel. Enjoy!

Insertion of Filled Radar Chart to Create Filled Radar Chart

Read More: How to Create an Area Chart in Excel (6 Suitable Examples)


Conclusion

In this article, I have tried to cover almost all the methods to create a radar chart with fill area in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo