Vba - change column graph color gradients with macro

**xandermacleod** · 09-26-2012, 06:10 AM

Hi there.

I have a simple column chart in a 2007 excel doc, and the bars have "2-stop" color gradient on them. Color stop 1 is bright orange, and color stop 2 is black.

I want to create a macro that changes the bright orange color to bright red using VBA.
___

I found this website, but I cant make sense of it - http://code.msdn.microsoft.com/offic...-with-ae123477

___

Ideally I want something of that looks roughly like:

ActiveChart.SeriesCollection(1).Interior.Fill.Gradient.ColorStop1 = RGB (255, 0, 0)

___

Any help is appreciated.

**Andy Pope** · 09-26-2012, 07:18 AM

Please Login or Register  to view this content.

**xandermacleod** · 09-26-2012, 07:24 AM

perfect! thankyou!

**spacely** · 12-13-2012, 12:26 PM

Hi Andy.

I have a related question. 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

Can you help?

**arlu1201** · 12-14-2012, 03:05 AM

spacely,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.