Microsoft Office Tutorials and References

In Depth Information

**Column**

Chart Types

Column

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.

Figure 19-15:

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.

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

you’re comparing

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.

Clustered

Stacked

100% Stacked

3-D