Hi all,

I figured this out in excel, but not in VBA

I have a line chart with 3 connected points. You can select a single point(excel 2010) and give that a "gradient line" fill. So in VBA, I'd like to make one end (stop @ 0) a given RGB color, and the opposite stop @ 1 another RGB color. I think the default is 3 stops, so I'd also have to make sure there are only the 2 end stops. I can then move to the next pont, do the same thing continuing with the color I left off with, and turn the whole line into a slowly changing color legend that I have prescribed.

I figured it out manually, just don't know the VBA code.

Hoping someone can help....thanks!