Microsoft Office Tutorials and References
In Depth Information
Formatting Chart Series
Additional series options
Chart series offer a number of additional options. These options are located in the Series Options tab
of the Format Data Series dialog box. The set of options varies, depending on the chart type of the
series. In most cases, the options are self-explanatory. But, if you are unsure about a particular series
option, try it! If the result isn’t satisfactory, change the setting to its original value or press Ctrl+Z to
undo the change.
Figure 7-11 shows an example of modifying series settings. The chart uses a Series Overlap of 50%
and a Gap Width of 28%.
Figure 7-11: A column chart, after adjusting the Series Overlap and Gap Width settings
About those fancy effects
Excel 2007 introduced several new formatting options, which are known as effects . Access these
effects by choosing Chart Tools➜Format➜Shape Styles➜Shape Effects. For more options, use the
Format dialog box. Note that not all effects work with all chart elements.
Following is a general description of the effect types:
Shadow: Adds a highly customizable shadow to the selected chart element. Choose from a
number of preset shadows, or create your own using the Shadow tab of the Format dialog
box. Shadows, when used tastefully, can improve the appearance of a chart by adding depth.
Glow: Adds a color glow around the element. Charts are rarely improved by adding a glow to
Soft Edges: Makes the edges of the element softer. Extreme settings make the element
appear to be out of focus, become smaller, or even disappear.
Bevel: Adds a 3-D bevel look to the element. This effect is highly customizable, and you can
use it to create a frame for your chart (see the accompanying figure).
3-D Rotation: This effect does not work with any chart elements.