Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting line graphs | Excel Discussion (Misc queries) | |||
conditional formatting in graphs | Charts and Charting in Excel | |||
automatically updating graphs based upon conditional variables | Charts and Charting in Excel | |||
Excel - conditional formating on graphs. Change colour on a value | Charts and Charting in Excel | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) |