How to create irregular polygon charts in Excel

Excel 2016
Many organizations utilize 360-degree feedback (also known as multi-rater feedback, multi-source feedback, multi-source assessment, or 360-degree review) to assist employees in work and social skills development. This process includes gathering employee's subordinates, colleagues, supervisor(s), and manager(s) feedback; and comparing self-evaluation and individual group metrics.

The irregular polygons chart helps to display 360-degree feedback in an easy to interpret form:

The irregular polygon charts in Excel 365

The irregular polygons show which traits the employee overestimates and which underestimates. Also, it is very significant when the self-estimation of the employee for different indicators is substantially different from the ratings of other participants in the assessment.

Irregular polygons belong to the family known as radar charts, spider charts, web charts, star plots, polar charts, cobweb charts, or Kiviat diagrams.

To create a chart of irregular polygons in Excel, do the following:

   1.   Select the chart data.

For example:

The data for irregular polygons chart in Excel 365

   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 365

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

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

Excel creates the chart from your data:

The simple irregular polygons chart in Excel 365

   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 365

Add any other adjustments you find useful for illustration purposes.

See also this tip in French: Comment créer des graphiques à polygones irréguliers dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

A radar chart for personality assessment test visualization

A radar chart for personality assessment test visualization

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.
How to compare strengths and weaknesses, skills, or performance metrics

How to compare strengths and weaknesses, skills, or performance metrics

Time to time, you need to compare strengths and weaknesses, skills, or performance metrics for people, teams, or companies. The dimensions have different qualitative meanings, and, if you choose a bar chart to plot such data, you need to create a separate graph for each aspect.
A quick way to duplicate all of the custom chart formatting

A quick way to duplicate all of the custom chart formatting

The creation of a large number of visually consistent charts to represent different data is a time consuming and error prone task unless you know how to copy formatting between charts.