Microsoft Office Tutorials and References
In Depth Information
HOW UP/DOWN BARS WORK
For charts that support this option, it is turned on and off in the Options tab of
the Format Data Series dialog box.
Except for pie charts and doughnut charts, this option is turned off by default.
You’ll find that this feature has quite a few limitations. For example, it is available
only when the chart has one series. And for an XY chart, the feature works only
with the default marker sizes. But, remember that you can format individual data
points within a series. Refer to Chapter 4 for more details.
Figure 5-30: This chart uses up/down bars to depict net profit by month.
Figure 5-31: Using up/down bars to create floating columns