Microsoft Office Tutorials and References
In Depth Information
Changing Your Charts
✦ Gridlines: To add or remove gridlines, click the Category Axis Gridlines
and Value Axis Gridlines buttons on the standard toolbar.
✦ Title: To change the title that appears on the graph, click the title to
select it; then click it again to edit the text. Move the title by selecting
it and dragging. You can also change the font by double-clicking it or
by right-clicking it and choosing Format Chart Title from the contextual
✦ Legend: To display or remove the legend — the table that explains
the meanings of the colors or symbols in the graph — click the Legend
button on the standard toolbar. Move the legend by dragging it to a new
location within the chart control. Change the fonts by double-clicking
the legend to display the Format Legend Entry dialog box.
Data table: Click the Data Table button on the standard toolbar to add a
table to the chart showing the data used in the table. You need to make
the control that contains your chart on your report bigger to make room
for the data table.
You can change other formatting options by making choices from the Chart
Objects drop-down menu, which is the leftmost item on the standard
toolbar. Choose Chart Area, Chart Title, Legend, or any of the other parts of the
chart; then click the Properties button on the same toolbar. (Actually, this
button looks just like the Properties button in Access, but its name changes
based on what object is selected. Anyway, just click it.) You see the dialog
box with the settings for that object.
Changing how data is graphed
When Microsoft Graph is up and running, you can also change the chart itself.
Just double-click the chart control in Design view to call up Microsoft Graph,
and follow these guidelines to change the chart: