ChartColorFormat.SchemeColor Property

  • Article
Excel Developer Reference

Returns or sets a Long value that represents the color of a Color object, as an index in the current color scheme.

Syntax

expression.SchemeColor

expression   A variable that represents a ChartColorFormat object.

Example

This example sets the foreground color, background color, and gradient for the chart area fill on chart one.

Visual Basic for Applications 
  With Charts(1).ChartArea.Fill
    .Visible = True
    .ForeColor.SchemeColor = 15
    .BackColor.SchemeColor = 17
    .TwoColorGradient msoGradientHorizontal, 1
End With