Export (0) Print
Expand All

ChBorder Object


This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Aa190083.parchild(en-us,office.10).gifChBorder

Represents the border of an object on a chart.

Using the ChBorder object

The following properties return a ChBorder object:

The ChChart object's Border property

The ChChartDraw object's Border property

The ChDataLabel object's Border property

The ChDataLabels object's Border property

The ChDropZone object's ButtonBorder property

The ChDropZone object's WatermarkBorder property

The ChLegend object's Border property

The ChPlotArea object's Border property

The ChPoint object's Border property

The ChSegmentBoundary object's Border property

The ChSeries object's Border property

The ChSurface object's Border property

The ChTitle object's Border property

Use the Color, DashStyle, and Weight properties to set the attributes of a border. The following example sets border properties for the legend of ChartSpace1.

Sub Format_Chartspace_Legend()

    Dim ChartLegend
    Dim chConstants

    Set chConstants = ChartSpace1.Constants

    ' Set a variable to the legend for the chartspace.
    Set ChartLegend = ChartSpace1.ChartSpaceLegend

    ' Set the legend color.
    ChartLegend.Border.Color = "Blue"

    ' Set the line weight for the legend.
    ChartLegend.Border.Weight = chConstants.owcLineWeightThick

    ' Set the line style for the legend.
    ChartLegend.Border.DashStyle = chLineRoundDot

End Sub

 

Show:
© 2015 Microsoft