• 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.

Is individual bar color something that can be conditional formatted + automated?

B

bricsa

New Member
Situation: I have route #s on one axis, revenue on the other axis.


Routes are classified by performance center. The numbers are sometimes intermingled. For example, while 100s are all one color, 200s are mostly another color - with the exception of 3 of the 200s.


The only way I know how to format the colors is to have as the base color the group with the most routes in it, then individually add the new color, click, use the repeat function.


Is there a way to automate this process? Perhaps VBA, but I hope there's something else? I have Excel 2007, 2010, and Excel Mac 2011 at my disposal. Thanks for any ideas!
 
Bricsa


Firstly Welcome to the Chandoo.org Forums


As you are using a Column or Bar chart there is a small workaround


You need to use multiple series for each Group

The series can be based on a Formula and will insert a N/A# error when there is no matching values


Use a formula like =If(and(Cell>100,Cell<200),Cell, Na())

to seperate the data into the various series

Then add all the series to the chart as a Stacked Column/Bar chart


Color each series as appropriate


As the data changes the series will add/remove the individual data to itself and the chart will change as required
 
You must log in or register to reply here.
Back
Top