Question - Excel Charts 2007 – Format Data Series - Gradient Fill

[ashfire]

Is there any way to change the Stop Position % based on a value in a cell ?


Cheers

 

[Hui]

What is a stop position?

 

[ashfire]

In the gradient fill section there is a stop position which allows you to dictate were the gradient finishes at. you can add multiple stop positions to one bar.


cheers

 

[Hui]

Ashfire

There is no way to link that to cell value

There is also no way to control that through VBA either


You can define a Gradient Fill manually and then apply a predefined gradient fill through a macro.


So you could setup a macro to swap the fills based on a number of pre-defined fill types.


I'm still using a Beta of Excel 2010 and so can't comment on 2007 or the final version of 2010.

 

[ashfire]

ah yes i remember reading a post about changing the bars now, ill see if i can dig it up


cheers again