Plots data on a common axis radiating out from the center of the chart.
Useful for plotting responses to questionnaires or performance reviews.
Available in wireframe (with or without markers) or filled versions.
Data Format
- x-axis: Categories (e.g. countries)
- Categories are identified in the legend.
- Chart can become visually complex with too many categories.
- Use wireframe chart for multiple categories otherwise filled plots overlap.
- y-axis: Data Series (e.g. questionnaire responses)
- Series are shown as geometric shapes with each data point plotted on one of the axes.
- All series work to a common scale. Series with different scales will need to be normalized.
| Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | |
|---|---|---|---|---|---|
| Category 1 | # | # | # | # | # |
| Category 2 | # | # | # | # | # |
Try it now!
- Select 2 countries using the dropdown lists to view responses to an 'Ease of doing business' survey.
- All indices were converted to a 0 - 10 scale, where 0 is poor and 10 is excellent.
- This chart was built using data validation lists, named ranges, conditional statements and the INDEX and MATCH functions.
Related Waterfall, Funnel, Stock, Surface or Radar Charts
- Funnel
- Stock (High, Low, Close)
- Stock (Open, High, Low, Close)
- Stock (Volume, High, Low, Close)
- Stock (Volume, Open, High, Low, Close)
- Surface
- Waterfall