how to determine the color with a value of column

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inverse colors in bar chart 1
How do I convert shading to highlighting for specific colors 8
One extra x axis item that wont go away - can anyone help? 3
how to change color gradients in a bar chart 0
changing area color based on line value 2
How can i change chart data point format based on value? 3
2007 column chart theme colors via VBA 3
For chart syles, why doesn't color order match series order? 1

Top