Different Fill Area on Simple Bar

[Rita Palazzi]

Windows XP Professional
Office 2000


I have a simple bar graph that shows the number of times a specific
"reason code" is used and only the top ten reason codes are shown on the
graph. Now, any reason code can fall into one of two different buckets.
I've been tasked with altering my graphs to not only show the number
of occurrences for each reason code, but to change the fill area of the
bars based on bucket assignment. I will leave one bucket property as
default, but would like to change any reason code bar that falls into
the second bucket to a different pattern.

Is there a way to do this programmatically so that I don't have to
change the series properties every time the graph is updated? While I
only have 10 bars on the graph, I have 7 of these graphs and it can
become quite cumbersome given they change weekly.

Thanks in advance for any help you can lend!!

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express


Example Data:

Reason Code Times used Bucket
RC_1 50 1
RC_2 61 1
RC_3 75 2
RC_4 15 2
RC_5 27 1

 

[Debra Dalgleish]

Jon Peltier has instructions for conditional charts:

http://www.peltiertech.com/Excel/Charts/format.html#CondChart

You could adapt those to your requirements.

 

[Rita Palazzi]

The instructions you referenced don't really apply here because I need
the color of the bar to change based on the what is ultimately the
series name for that bar as opposed to the value. Any other suggestions?

Thanks
Rita

 

[Debra Dalgleish]

Change the formulas to check for the series name, instead of the value.
A Vlookup function can return the bucket for the series. For example:

=IF(VLOOKUP($A4,BucketList,2,0)=D$3,$C4,NA())