ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Conditional Formatting" of Bar Graph data (https://www.excelbanter.com/excel-discussion-misc-queries/207140-conditional-formatting-bar-graph-data.html)

WildWill

"Conditional Formatting" of Bar Graph data
 
Hi

I have the following data set, which I will display on a Bar/Column Graph:

A B
Quality 82%
Delivery 20%
Ethics 93%

Considering the above data on a Bar/Column Grasph, I want to add a condition
that any value below 50% will be displayed in a red coloured bar. Is this
possible?


Bob Phillips[_3_]

"Conditional Formatting" of Bar Graph data
 
See http://peltiertech.com/Excel/Charts/...html#CondChart

--
__________________________________
HTH

Bob

"WildWill" wrote in message
...
Hi

I have the following data set, which I will display on a Bar/Column Graph:

A B
Quality 82%
Delivery 20%
Ethics 93%

Considering the above data on a Bar/Column Grasph, I want to add a
condition
that any value below 50% will be displayed in a red coloured bar. Is this
possible?




WildWill

"Conditional Formatting" of Bar Graph data
 
Thanks Bob!

"Bob Phillips" wrote:

See http://peltiertech.com/Excel/Charts/...html#CondChart

--
__________________________________
HTH

Bob

"WildWill" wrote in message
...
Hi

I have the following data set, which I will display on a Bar/Column Graph:

A B
Quality 82%
Delivery 20%
Ethics 93%

Considering the above data on a Bar/Column Grasph, I want to add a
condition
that any value below 50% will be displayed in a red coloured bar. Is this
possible?






All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com