PDA

View Full Version : Solved: changing plot area of chart to have gradient look



divingdingo
11-27-2007, 09:18 AM
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
11-27-2007, 10:33 AM
What kind of gradient? One colour, two colour or preset? Look up the ChartFillFormat object in Help for more details.

divingdingo
11-28-2007, 02:37 AM
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
11-28-2007, 04:03 AM
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