Microsoft Office Tutorials and References
In Depth Information
HOW UP/DOWN BARS WORK
In a stock market chart, up/down bars (sometimes referred to as candlesticks )
connect the day’s opening price with the closing price. If the closing price is higher
than the opening price, then the bar is hollow (white). Otherwise, the bar is black.
These are default colors; you can format up/down bars any way you like.
HOW UP/DOWN BARS WORK
If you plan to use up/down bars in a chart, you need to understand how they work.
Up/down bars rely on the plot order of the series. The up/down bars always connect
the first series with the last series. If a line chart has six data series, the up/down
bars will connect the first and the sixth. The only way to control which series get
connected is to change the series plot order. You can do this by using the Series
Order tab of the Format Data Series dialog box for any data series.
Refer to Chapter 3 for more information about changing the plot order for
To add up/down bars to a line chart, access the Format Data Series dialog box
for any series. Select the Options tab and place a checkmark next to the Up/Down
Bars check box. If the up/down bars do not connect the desired series, adjust the
To change the formatting, double-click an up/down bar to access the Format Up
Bars dialog box. Also, note that when a chart has up/down bars, the Options tab of the
Format Data series dialog box includes an option to change the gap between the bars.
USING UP/DOWN BARS IN NON–STOCK MARKET CHARTS
Figure 5-30 shows a line chart with up/down bars. The first series plots income and
the second plots expenses. The up/down bars connect each corresponding data
point and represent the net profit for the month. Note that, in January, expenses
exceeded income, so the up/down bar for that month displays in a different color.
Another example of up/down bars is shown in Figure 5-31. This is a line chart
with two series that display the normal high and low temperatures, by month. The
lines are connected by up/down bars.
You’ll notice, however, that the lines are invisible. This effect was done using the
Patterns tab of the Format Data Series dialog box — the Line option was set to None.
The result is a “floating column” chart that is not obscured by lines.
Varied colors for data points
Some chart types have an option that enables you to vary the color for each data
point. Contrary to what you might expect, this option does not allow any type of
conditional color formatting based on values.