April 2006
Beginner
1114 pages
98h 16m
English
chartfillformat.UserTextured(TextureFile)
Applies a picture file as a texture to the fill. Pictures are tiled to fit the fill area.
|
Argument |
Settings |
|---|---|
|
|
The filename of the picture to apply |
The following code tiles a picture to fill the chart area:
Sub UserPictureTexture( )
Dim chrt As Chart, cf As ChartFillFormat
' Get the chart.
Set chrt = ActiveChart
' Get the chart area fill.
Set cf = chrt.ChartArea.Fill
' Make the fill visible.
cf.Visible = True
' Display a picture.
cf.UserTextured ThisWorkbook.Path & "\logo.bmp"
End SubRead now
Unlock full access