chapter 18: the graphics programs of ofﬁce x 669
As in Excel, cells are labeled with letters and numbers; unlike Excel, Graph’s spread-
sheet has an extra row at the far left and an extra column at the top. You’re supposed
to type row and column headers into these special dedicated areas. Graph will then
use these cells in the chart for its axes and for the legend.
As you work, you can make these kinds of changes to your chart:
• Change the chart type. Microsoft Graph can produce every chart type that Excel
can, but it starts out with a vertical bar graph. To change this chart type, choose
one of the eighteen options found in the Chart Type pop-up button in the Stan-
dard toolbar. (If you can’t ﬁgure out which icon it is, point to the toolbar icons
without clicking and read the resulting tooltips). (See Chapter 13 for a discus-
sion of which chart type to use with which kinds of data.)
To use a chart type that isn’t present in the Chart Type palette, choose
Chart→Chart Type to open the Chart Type window. This window is nearly iden-
tical to the Chart Type window in Excel and features the same range of chart
• Swap axes. If Graph is showing the data on the wrong axes, click the By Row or
By Column button in the Standard toolbar—either will swap the chart’s hori-
zontal and vertical dimensions.
• Change element colors. To change colors in a chart, simply click the element that
you want to change (such as a bar or its background) and then select a new color
from the Fill Color pop-up button (the “pouring paint can” icon) in the Stan-
• Move or resize something. You can move the chart’s legend by dragging it. Most
other graph elements are ﬁxed in place, but you can resize something (such as the
legend or the chart’s plot area) by clicking it and then dragging one of the resize
handles that appear at its corners. If you have a 3-D item in a chart, you can also
drag its corners to rotate it, just as you can in an Excel chart containing a 3-D
Tip: If you really want to ﬁne-tune control over a 3-D object, choose Chart→3-D View, which produces a
control window in which you can control the exact rotation of a 3-D object.
• Change the fonts. You’re not stuck using Geneva in your tables. To change the
font, select the item in question (label, axis, whatever) and then choose
Format→Font to bring up the Format window, where you can tweak the font
size, style, color, underline, and so on. Click OK to save the changes.
• Add a data table. If you want to include a data table (which displays the cells used
to make the chart), click the Data Table button in the Standard toolbar. It plops
the data table below the chart.