conditional formatting of bar graphs
 

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.

conditional formatting of bar graphs
 

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.

conditional formatting of bar graphs
 

DEAR,
U CAN PLOT A GRAPH 3 AXIES WHICH IS IN EXCEL ALREADY & KEEP THIS GRAPH ON
ANOTHER SHEET,THEN SAVE IT & THEN IF U JUST CHANGE THE VALUE ON FIRST SHEET
YOUR GRAPH AUTOMATICALLY CHANGES IN SECOND SHEET (BUT U HAVE TO DESIGN THE
GRAPH (TYPE OF THE GRAPH) EARLIER

THANKS
AVINASH

"Stacey" wrote in message
...
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.

conditional formatting of bar graphs
 

Thank you so much. That worked and will be easy for me to implement. I
appreciate the help

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

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.

conditional formatting of bar graphs
 

Change the number format to "0.00%;0.00%;". Now there are three elements,
and the third, which is blank, is for zero values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Michael R" wrote in message
...
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.

conditional formatting of bar graphs
 

Thanks, Jon, works a treat

"Jon Peltier" wrote:

Change the number format to "0.00%;0.00%;". Now there are three elements,
and the third, which is blank, is for zero values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Michael R" wrote in message
...
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.