Gradient for bars in 2D scroll chart

[orangehump]

I'd like my bars to go from a dark version of a colour to a light version of the colour. For example: bar 1: dark green to light green, bar 2: dark yellow to light yellow etc.... <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

I can only seem to define a global colour for a gradient. For example, defining "plotGradientColor='ffffff'" causes all gradients to go from white to the colour defined in the dataset color ='...'

 

For clarity...

Thanks in advance for any help.

[orangehump]

I figured it out. In case anyone else is wondering how to do it...

<set value='23' color='ecd782,c3a854'/>