• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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
 
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.
 
ah yes i remember reading a post about changing the bars now, ill see if i can dig it up


cheers again
 
Back
Top