setting gradient stops in a chart (2007)

Topic

New Reply

Aloha folks,

I’m trying to make the shading of the plot area change based on the data being plotted. I have the plot area set to a gradient fill with 4 stops. I want to change the positions of stop 2 and stop 3 based on the maximumvalue of the value scale.

I’m having trouble getting the path for and setting the gradient stops. What I want is to change the stop point for stop 2 and stop 3. Can someone help me with syntax?

Reply | Quote

Replies

Sorry about the lack of replies. I guess that not many users have tried the new gradient options in Excel 2007 yet (I don’t have 2007 at all).

Reply | Quote

You set the position of gradient stops as a percentage, using syntax like:
activechart.PlotArea.Format.Fill.GradientStops(2).position = 0.33
if that helps?

Reply | Quote

YESSS! Thank you Rory.

So what is the secret to finding the path to such an item as a ‘GradientStop’? I flopped around for three hours in the Excel Object Model Reference unsuccessfully. I mean, how is one supposed to decipher that one uses the Format property to get at the ChartFormat object and then the Fill property to get at the FillFormat object and thus have access to the GradientStops? There HAS to be a better way. MS’s Help system often only helps you if you know what you’re looking for and where. Their examples suck, pardon the vernacular.

Mahalo and aloha,
John Jacobson

Reply | Quote

I use the Object Browser. Excel 2007’s Help files are an abomination in my opinion and about as useful as a chocolate teapot!

Reply | Quote