A radar chart for personality assessment test visualization

Excel 365
Today, HR professionals in large companies build detailed personality profiles, which include scores of workplace-oriented behavioral indices of the employee. The behavioral scores cover such areas as leadership, communication skills, interpersonal finesse, empathy, diligence, rationality, analyticity, etc. Here radar charts become especially handy because tables, bars, and lines look cluttered and are hard to analyze for a large number of variables.
The radar chart in Excel 2016

Some human resources experts identify them as spider charts, web charts, star plots, irregular polygons, polar charts, cobweb charts, or Kiviat diagrams.

To create a radar chart in Excel, do the following:

   1.   Select the chart data.

For example:

The data for radar chart in Excel 2016

   2.   On the Insert tab, in the Charts group, click the Insert Waterfall, Funnel, Stock, Surface, or Radar Chart dropdown list:

The Insert Waterfall, Funnel, Stock, Surface or Radar Chart button in Excel 2016

Select the Radar, Radar with Markers, or Filled Radar:

Radar, Radar with Markers or Filled Radar charts in Excel 2016

Excel creates the chart from your data:

The simple radar chart in Excel 2016

   3.   Select the title and change it or remove it.

   4.   Select the axis and remove it.

   5.   Right-click on any of the data point and choose Add Data Labels -> Add Data Labels in the popup menu:

Add Data Label in Excel 2016

A radar chart with data labels completely replaces the scores table.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.