conditional formatting of bar graphs
Thanks, this solution came in very handy for me too!
But here is one more challenge with it:
In the bars I display data labels (values). The values are percentages
(formatted "0.00%;0.00%")
I received loads of #NAs as labels; I have already replaced the NA() in your
formula =IF(B2="Y",C2,NA()) by "" (empty), but then the unwanted labels
display as "0.00%".
How can I suppress labels if they are #NA or zero or empty?
"Barb Reinhardt" wrote:
Create a couple of helper columns, one for Specialist = Y and One for
Specialist = N
Put this in the Specialst = Y column
=IF(B2="Y",C2,NA())
In the Specialist = N column, use the same equation, but replace Y with N.
Create a stacked bar chart with the data from the two helper columns.
HTH,
Barb Reinhardt
"Stacey" wrote:
I have 3 columns of data: Manager, specialist indicator, sales growth
(columns A,B,C). I want to put a bar graph together to show the sales growth
by manager and make the ones with the specialist indicator = "Y" a different
color. Can I do this automatically or will I have to do this manually each
month I run this report? Thank you.
|