The Radar Chart is a built-in chart type in Excel. Radar charts, sometimes called spider charts , have one axis per category which all use the same scale. The axes of a radar chart radiate out from the center of the chart and data points are plotted on each axis using a common scale. The result is a geometric shape that shows “at-a-glance” performance across all categories.
Radar charts can be used to plot the performance of employees, athletes, products, and companies in various categories. They can be used for performance evaluations and satisfaction surveys.
Pros
- Compact presentation
- Can show at-a-glance strength or weakness
- Can handle more than one data series
Cons
- Unusual chart type may confuse audience
- More difficult to read for most people
The Bubble Chart is a built-in chart type in Excel. Bubble charts are a special kind of XY chart that can display another data series which is used to scale the bubble (marker) plotted at X and Y values. You can think of a bubble chart as “X versus Y, scaled by Z”. Like a regular XY scatter chart, both axes are used to plot values – there is no category axis.
Pros
- Can show the relationship of one variable to another
- Unique ability to show data about a third dimension
- Can visually display correlation
Cons
- Unusual chart type may be difficult to ready for many people
- More difficult to set up than other chart types
