How to Insert a Radar Chart in Microsoft Excel

Date:2020-2-4 Author:Olivia

We’ve already shared the tip of how to insert line chart, pie chart and histogram in Excel, but sometimes they cannot meet the needs of data analysis. Here is another type——radar chart, which is equivalent to a parallel coordinates plot, with the axes arranged radially, and also a useful way to display multivariate observations with an arbitrary number of variables. So how can we insert a radar chart? Here’s a simple guide.

1. Enter all data you want to analyze, here I will take the income for past three years as an example.

How to Insert a Radar Chart in Microsoft Excel

2. Select all items, and go to Insert tab, click Radar Chart button in Charts group, and you can select one from three symbols in the drop-down list of Rader section. Here I prfer the second type, which means Radar with Markers.

How to Insert a Radar Chart in Microsoft Excel

3. Now the original radar chart is displayed in the worksheet as below.

How to Insert a Radar Chart in Microsoft Excel

4. Then go to the Design tab, you can modify the Chart Styles, click the drop-down arrow for more information. Here I choose the Style 4, to insert background color for this chart. Also you can rename the title of it.

How to Insert a Radar Chart in Microsoft Excel

5. Let’s see what will the chart look like after step 1-4.

How to Insert a Radar Chart in Microsoft Excel

6. Next, click Quick Layout in Design tab, you can change the layout with four choices. Here I choose Layout 1.

How to Insert a Radar Chart in Microsoft Excel

7. You can see the radar chart has been completed, and it might be easier for us to do data analysis in Microsoft Excel.

How to Insert a Radar Chart in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *