O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ChartFillFormat Members

Use the ChartFillFormat object to apply colors, gradients, and patterns to objects on a chart. Use the Fill property to get a reference to this object. The ChartFillFormat object has the following members . Key members (shown in bold) are covered in the following reference section:

Application

BackColor

Creator

ForeColor

GradientColorType

GradientDegree

GradientStyle

GradientVariant

OneColorGradient

Parent

Pattern

Patterned

PresetGradient

PresetGradientType

PresetTexture

PresetTextured

Solid( )

TextureName

TextureType

TwoColorGradient

Type

UserPicture

UserTextured

Visible

These chart objects all have Fill properties, which return a ChartFillFormat object:

AxisTitle

ChartArea

ChartTitle

DataLabel

DataLabels

DisplayUnitLabel

DownBars

Floor

Legend

LegendKey

PlotArea

Point

Series

Shape

ShapeRange

UpBars

Walls

 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required