Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
Farewell to pivot charts
Earlier versions of Microsoft Access included
an additional chart type: pivot charts. This
capability has been removed from Access
2013. Pivot charts are still available in Excel
Now you know how to use the Chart Wizard to create a chart. The next few
sections describe popular types of charts.
Making bar charts
The Chart Wizard can make a bunch of kinds of bar charts, some with
vertical bars and some with horizontal bars. The types of bar charts in which the
bars run vertically appear in the first row of buttons shown in Figure 3-3,
earlier in the chapter. Here’s some information on what you can create with
✦ Column Chart: Flat vertical bars.
✦ 3-D Column Chart: Three-dimensional–looking vertical bars.
✦ Cylinder Column Chart: Same thing as a column chart, but the bars are
✦ Cone Column Chart: Another column chart, but with cones instead of bars.
✦ Pyramid Column Chart: Same as the preceding two charts, but with
pyramids instead of cones or bards.
You can also make the same charts run horizontally. The following buttons
appear in the second row of buttons in Figure 3-3:
✦ Bar Chart: Flat horizontal bars.
✦ 3-D Bar Chart: Three-dimensional–looking horizontal bars.
✦ 3-D Cylinder Bar Chart: Same thing as a bar chart, but the bars are
✦ 3-D Cone Bar Chart: Another bar chart, but with horizontal cones. (They
look rather odd, we think.)
✦ 3-D Pyramid Bar Chart: Same as the preceding two charts, with
horizontal pyramids (which look even odder).
Unfortunately, the Chart Wizard can’t draw stacked bar charts. To make
them, you have to choose another type of bar chart in the Chart Wizard and
then change the chart type to a stacked bar chart later (see “Changing Your
Charts,” later in this chapter).