Solved: changing plot area of chart to have gradient look

[divingdingo]

hi all

just wondered if anyone new the code to change the activechart.plotarea to a gradient setting

and where i could find the codes for each type of gradient

much appreciated

mark

[rory]

What kind of gradient? One colour, two colour or preset? Look up the ChartFillFormat object in Help for more details.

[divingdingo]

cheers rory, that's wicked helpfull, i was thinking it was plotarea.gradient !! so couldn't find the right object in the help files,

still do you know where i can find a list of the colour codes, so i know which numbers = which colours

regs
mark

[divingdingo]

for anyone else how has been following this thread heres the code i've used to achieve the gradient effect on a chart:

With Charts("name of chart").PlotArea.Fill
.Visible = True
.ForeColor.SchemeColor = 37
.BackColor.SchemeColor = 17
.TwoColorGradient Style:=msoGradientHorizontal, variant:=1
End With

i looked up the colour palette at this website:

http://www.geocities.com/davemcritchie/excel/colors.htm

case closed!!

cheers rory,

regards
mark