Today, this tutorial gives you an introduction to how to quickly make a radar map through Excel.
Specific steps to operate:
1, the following table as an example of the production of radar map, three classes each subject scores are listed.
2. Select all cells in the table
3, choose to Insert, click on the other icon below the inverted triangle, and then click on one of the radar map format.
4, see it, radar chart on the production.
5, through this radar map can see a lot of information, such as Class B's language and foreign language performance is the worst, the remaining three subjects are good, there are leaning branch phenomenon, a class of foreign language and physical performance of the worst, need to catch up, C class chemistry and maths poor results.
Warm tips:
Radar chart best within the same standard analysis, the gap is too large analysis is not accurate, Excel graphics production needs a variety of graphic combination to make exquisite charts.