Help
Topics
Formatting Data Series
The Format Data Series dialog lets you pick the color to use for each data
series in your chart. To set the color and related format options for a data
series
- Mouse over the data series you want to format.
A blue rectangle box appears, indicating it is a hot spot for the data series.
- Right-click on the hot spot and select Format Data Series....
The Format Data Series dialog box appears.
You can now pick a color from the color palette for the data series.
In addition, the Format Data Series dialog offers different
format options depending on the chart type:
Bar and 3D Bar Charts
For each data series in a bar or 3D bar chart, you
can set its color by selecting a color from the color palette.
For the other options in the dialog, your selection is applied to all
data series in the chart. These include the following options:
- hide or show the data labels (whether to show the data values next to the
data series)
- hide or show the series border (whether to draw a black outline for data
series)
- chart absolute values (to have negative values treated as positive and charted
accordingly)
- set the depth of the 3-D effect (0 to 100)
Line and Area Charts
For each data series in a line or area chart, you
can specify:
- its color by selecting a color from the color palette
- whether to use a marker to indicate data points
- if using a marker, the shape to use
- if using a marker, the size it should be (0 to 100; A value of 30 is about
10 pixels. A value of 100 is about 30 pixels)
For the other options in the dialog, your selection is applied to all
data series in the chart. These include the following options:
- hide or show the series border (whether to draw a black outline for data
series)
- chart absolute values (to have negative values treated as positive and charted
accordingly)
- set line width
- set 3-D effect depth (0 to 100)
Pie Charts
For each data series in a pie chart, you can specify
its color by selecting a color from the color palette.
For the other options in the dialog, your selection is applied to all
data series in the chart. These include the following options:
- hide or show the series border (whether to draw a black outline for data
series)
- chart absolute values (negative values are treated as positive and charted
accordingly)
- starting what values (in %) should data series with small values be grouped
- whether to show the data label, the connecting feeler line, or to show the
labels on the slices
Bubble and Scatter Charts
For each data series in a bubble or scatter chart,
you can specify its color by selecting a color from the color palette.
For the Show series border option, your selection is applied to all
data series in the chart.
Waterfall Charts
Waterfall charts are usually used to show how a measurement changes over time,
and the various elements which make up that change. It typically shows how an
initial value is increased and decreased by a series of intermediate values,
leading to a final value.
A waterfall chart is composed of four types of values: absolute positive, absolute
negative, relative positive, and relative negative. For each
type of value, you can specify its color:
- Click the Change button next to value type you want to
modify.
- Select a color from the popup color palette and click OK.
- Repeat step 1 and step 2 until the desired colors are selected.
- Click OK to apply the color selections to your waterfall
chart.
Related Topics: