Microsoft Office Tutorials and References
In Depth Information
Formatting the Data Series
Gridline spacing is based on the major and minor units that you have set in the Format Axis dialog box (vertical or
horizontal). To set this spacing, see “Setting Axis Scale Options” earlier in this chapter.
Walls are nothing more than the space between the gridlines, formatted in a different color
than the plot area. You can set the walls’ fi ll to None to hide them. To set the wall color,
right-click the wall and choose Format Wall, and then choose a fi ll color in the Format Wall
task pane.
You can format walls only on 3-D charts; 2-D charts do not have them. To change the background behind a 2-D chart,
you must format the plot area.
Formatting the Data Series
To format a data series, just right-click the bar, slice, or chart element, and choose Format
Data Series from the shortcut menu. Then, depending on your chart type, different series
options appear that you can use to modify the series appearance. Here are the icons avail-
able for bar and column charts, for example:
Fill & Line. These options enable you to choose a fi ll and a border for the series,
with choices for fi ll including solid, gradient, or picture/texture. Under Border
you can choose a border color, style, and thickness. This is just like fi lling drawn
shapes, as you learned in Chapter 9.
Effects. These options include the same standard options available for any drawn
object, including Shadow, Glow, Soft Edges, and 3-D Format.
Series Options. This section contains options that are specifi c to the selected
chart type. For example, when you’re working with a 3-D bar or column chart, the
series options include Gap Depth and Gap Width, which determine the thickness
and depth of the bars. For a pie chart, you can set the rotation angle for the fi rst
slice as well as whether a slice is “exploded” or not. For charts involving bars and
columns, you can choose a shape option such as Box, Full Pyramid, Partial Pyramid,
Cylinder, Full Cone, or Partial Cone. The partial options truncate the top part of the
shape when it is less than the largest value in the chart.
Other chart types have very different series options available. For example, a line chart has
Marker Options, Marker Fill, Line Color, Line Style, Marker Line Color, and Marker Line Style.
Rotating a 3-D Chart
3-D charts can be rotated in one or more directions: X (side to side), Y (top to bottom), and
Perspective (the angle from which you view it). There is also a Z rotation (pivoting around a
center point), but it is inactive for most chart types.
 
Search JabSto ::




Custom Search