Dear All,
I would like to know how can I conditional format this chart:
Objective: "Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. Currently, the graph colors are different (random colors).
Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. "Currently, the graph colors are different (random colors).
So, basically I want the graph colours to change in either Red or Green depending on a percentage level.
Would be thankful for your help.
* I could not figure out how to upload attachment *. I can email the file if you share email address or please let me know how to upload the file"
Thanks.
I would like to know how can I conditional format this chart:
Objective: "Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. Currently, the graph colors are different (random colors).
Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. "Currently, the graph colors are different (random colors).
So, basically I want the graph colours to change in either Red or Green depending on a percentage level.
Would be thankful for your help.
* I could not figure out how to upload attachment *. I can email the file if you share email address or please let me know how to upload the file"
Thanks.