Excel 2019 Bible

(singke) #1

Part III: Creating Charts and Other Visualizations


FIGURE 20.29
This 3-D area chart is not a good choice.

Radar charts
You may not be familiar with this type of chart. A radar chart is a specialized chart that
has a separate axis for each category, and the axes extend outward from the center of the
chart. The value of each data point is plotted on the corresponding axis.

Figure 20.30 shows an example of a radar chart on the left. This chart plots two data series
across 12 categories (months) and shows the seasonal demand for snow skis versus water
skis. Note that the water-ski series partially obscures the snow-ski series.

FIGURE 20.30
Plotting ski sales using a radar chart with 12 categories and two series
Free download pdf