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.
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.
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 much better option is to normalize the data and
use a spider chart, which renders multiple axes with the same scale.
Because of different standards of different countries and cultures, there is a lot
of situations when you need to change commas to dots, decimal points or dots, decimal
points to commas in an Excel spreadsheet:
Excel offers a lot of different tricks to create great informative charts and diagrams. A lot of
the useful adjustments related to the axis. E.g., you can hide an axis, use primary and
secondary axis, change the presentation of data on the axis, etc.
There are a lot of different pre-defined charts in Excel, but for some types of data, pre-defined
charts such as area chart or line chart can look fine but are incorrect.