We use charts to better represent the data and provide the concept and purpose of the data. Despite its many features and abilities, the radar chart or spider diagram in Word is a graphing chart which is less used. It may due to people that are less familiar with this chart. In this tutorial, we will introduce and explain How to insert a radar chart in Word.
The radar chart is used to compare several indicators in several different fields. This chart is available in 3 ways.
- Radar: Polygon Linear (Empty)
- Radar with Marker: Linear Polygon Graph with Marker (Empty)
- Filled Radar: colored and Spider Chart (Fill)
Suppose that we want to compare the planed budget and the actual budget in different fields. You may find the first option column chart. We will see how we use the radar chart to display this type of data in better way.
The planned budget and the actual budget for a company in the fields of marketing, sales, management, IT and after-sales services. Insert the data in Word in accordance with below image.
Now select the data and use the Insert tab and select the Chart pane. Then, choose Radar.
As you can see in below image, planned and actual budget are compared in different indices. For example, we see that in the field of management, IT and after-sales services, the planned and the actual budget are almost consistent and there is no deviation. But in terms of marketing and sales, the amount spent has been more than program budget.
So, in general, the indices or factors in this graph are a regular polygon (we have 5 indexes, a regular pentagon was created), and the values for each field are displayed on this polygon as an irregular polygon. (Red pentagon, for real and blue for the planned budget).
If you select the Radar with Marker option, the same radar chart is displayed as dotted. Of course, this feature is also available in the Format section and we can marker the graph.
The Filled Radar Chart is displayed as a fill screen. Be sure to look at below image, the actual budget is displayed as a solid polygon, with a planned budget located behind it.
We need to change that field’s Transparency to modify the display of this chart. To do this, just select the desired polygon, right-click and select Format Data Series. From the popup window, select the Solid Fill option from the Marker and Fill fields and set the transparency value.
Now that we’re familiar with the radar or spider diagram, we can use this graph for comparative data in addition to the column, bar, and line pie, which is far more professional and attractive. Comment on How to insert a radar chart in Word to improve it and make it better.