Microsoft Office Tutorials and References
In Depth Information
21.8.1 UpBars and DownBars
21.8.1 UpBars and DownBars
UpBars and DownBars are shown in Figure 21-17 . These bars give a quick indication of the
difference between data values in two different data series of line type. The UpBars are in white
and DownBars are in black. The code to generate these bars is:
With ActiveChart.LineGroups(1)
.HasUpDownBars = True
.UpBars.Interior.Color = RGB(255, 255, 255)
.DownBars.Interior.Color = RGB(0, 0, 0)
End With
Note that UpBars and DownBars apply only to 2-D line-type charts.
Figure 21-17. UpBars are in white and DownBars are in black
21.8.2 DropLines
DropLines are vertical lines that extend from the data markers on a line chart to the category axis.
The HasDropLines property of the ChartGroup object can be set to True to display DropLines.
Search JabSto ::

Custom Search