Excel offers 100% versions of column charts, bar charts, area charts, and line charts. To
find them, in the Insert Chart dialog, you look for charts where both the left and right ele-
ments are the same height (see Figure 4.19).
4
Figure 4.20 shows examples of 100% stacked column, area, bar, and line charts. The 100%
stacked column chart is probably the easiest to interpret. In a 100% stacked chart, the
reader is able to judge the growth or decline of both the first series and the last series.
Figure 4.19
These icons all create
100% stacked charts.
Figure 4.20
For year-over-year com-
parisons,a 100% stacked
column chart is ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.