I have a bar chart with two bars. These values are changing continuously. Is there a way I can conditionally format the chart so that the bigger bar is green?
Thank You
I have a bar chart with two bars. These values are changing continuously. Is there a way I can conditionally format the chart so that the bigger bar is green?
Thank You
You should be able to double click the bar you want to change then select fill, solid fill, then click the dropdown for Color and select the color you want.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
The easiest way to do this is not to use a chart at all (the old fashioned way!)
Use the REPT function to create the 2 bars
Then conditionally format based on whether value A or value B is the greater
See attached workbook and try different values in A3 and B3
The trick:
1. Formulas in cell A1 and B1 respectively:
Formula:Please Login or Register to view this content.
2. Cells A1 and B1 font = Marlett
3. Cells A1 and B1 conditionally formatted based on relative values of A3 and B3
so dependent on whichever value is greater, either A1 or B1 is conditionally formatted green
trickery.jpg
Otherwise, here is a good place to start reading
Last edited by kev_; 06-30-2017 at 01:14 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Create a chart with 2 series and control the data points with formula.
Format the colour of each series and set the series overlap to 100
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks