Microsoft Office Tutorials and References
In Depth Information
Advanced Chart Formatting Options
for example, you’ll see a dialog box with tabs that are appropriate for that element. The
selection might include ill, line, and border colors and shadows and glows, in addition to
options that are appropriate to the current selection.
Each chart type has a different set of options for handling series and elements that are
unique to that chart type. For example, you can use the options on the Marker Line Style
tab for a line chart with data markers for extremely fine control over the appearance of
those lines.
To fine-tune the arrangement of points in an individual data series, use the Series Options
page in the Format Data Series dialog box. The specific options vary by chart type. In line
and area charts, for example, you can plot individual series on a secondary axis—in that
configuration the primary vertical axis remains on the left and a second set of numbers
appears on the right. This allows you to plot two data series on the same chart and show
the relationship between them even when the scale is dramatically different for each one.
With bar and column charts, you can set the overlap between series (columns) and the
gap between groups. Figure 13-17 shows the options for a clustered column chart. We
changed the default Series Overlap setting from 0% (each column butts up directly against
the one next to it) to –10%, which leaves a slight gap between columns in each cluster. We
also reduced the default gap between clusters so that it’s exactly equal to the width of one
Search JabSto ::

Custom Search