WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

How to create radar chart

Uploaded time: January 24, 2022 Difficulty Intermediate

How to create radar chart

How to create radar chart

Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.

Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear.

1. Select the needed cell range, click the Insert tab and click the Radar drop-down button.

2. We select Filled Radar here to get a radar chartcorresponding to the selected cells.

3. If we want to beautify the chart, double click the chart and choose a  desired color in the Fill area to fill the chart.

4. Then we find the text does not appear clearly against this background, so we can click the Text Tools tab, select the text that we need to edit, and click Text Fill to change its color to white.

We can also change the fill color blocks of these three employees.

5. Select one of the fill color blocks, and choose a preferred color in the Fill area.

6. Since the overlapping data of these three employees are indistinguishable, we can select the color blocks to change their transparency one by one.

7. Lastly, click the radar chart, click Chart Elements on the right, and then select Left in the Legend area to place the legend to the left.

Such a simple yet elegant radar chart is done. With this chart, you can quickly find the employee with the highest overall quality.

In addition to this example, radar charts can be applied to diverse scenarios such as enterprise financial reports, employee ability analyses, competitive product comparison, etc.Did you get it?

Use WPS Office to edit your future. Better life with WPS all-in-one software, work with WPS in both PC and Mobile. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.