Microsoft Office Tutorials and References
In Depth Information
By now, column charts probably seem like old hat. But column charts actually come
in several different variations (technically known as subtypes ). The main difference
between the basic column chart and these subtypes is how they deal with data tables
that have multiple series. The quickest way to understand the difference is to look at
Figure 19-15, which shows a sample table of data, and Figure 19-16, which charts it
using several different types of column charts.
This simple table of data records the number of female and male students in
several rooms at a university. The category is the room name, and there are
two data series: the numbers of male students, and the numbers of female
students. This data is perfect for a column chart, but different subtypes
emphasize different aspects of the data, as you can see in Figure 19-16.
The Clustered Column
makes it easy to compare
the gender of students in
each room, but makes it
somewhat more difficult to
compare different rooms.
The Stacked Column is an
elegant way to compress the
data, and it lets you compare
the total number of students
in each room without losing
the gender information.
The 100% Stacked Column
makes each column the
same height, so it’s useless
for comparing total student
numbers but perfect for
comparing how the gender
breakup varies depending on
the room. (Notice the scale
also changes to reflect that
percentage values.) Finally, the 3-D
chart shows you all the data
at once by placing the male
student counts in front of the
female student counts.