how to determine the color with a value of column

  • Thread starter Thread starter Kamyk
  • Start date Start date
K

Kamyk

I have the following problem. I have a percent column chart. I have only one
series. In this case all columns will have the same color on the chart. I
want these column colored regarding to the value of a column. I mean:
- value: 80% color: yellow
- value: 100% color: greeen
- value: 40% color: red

How to condition the color of the column with a percentage shown on the
chart? I mean something like the conditional formatting, but on charts?

Thanks in advance
Marcin
 
Back
Top