Microsoft Office Tutorials and References
In Depth Information
In the Axes group, clicking Gridlines enables you to determine whether the chart displays
horizontal and vertical gridlines and, if it does, at what value intervals they should appear.
In addition to changing your chart’s layout, you can control the appearance of each
element within the chart. To select a chart element to format, click that element. For
example, if you want to change the formatting of the data series named Volume in the
column chart you created in the previous exercise, clicking any column in the series
selects the entire series. Any formatting changes you make then apply to every point
in the entire series. If you want to change a single data point, select the entire series,
and then click the chart element (for example, a column) that represents the data point
you want to change. For example, you can highlight the column representing the year
2008 in the chart you created in the previous exercise.
You can display a list of the selectable chart elements by selecting the chart and then,
on the Format tab, in the Current Selection group, clicking the Chart Elements arrow.
Then just click the desired chart element to select it.
After you select the chart element, you can drag one of the element’s handles to resize
the element or drag the element to another location within the chart. To change the chart
element’s format, use the tools and dialog box launchers in the Format tab’s Shape Styles,
Word Art Styles, Arrange, and Size groups to change the element’s appearance. You can
also select the chart element and then, on the Format tab, in the Current Selection group,