Hi all,
looking to have a column chart, that changes colour depending on the value.
for example from 0- 10 red and at the value 10 green.
unsure on where to input this code ( itemcolorset or Color? )
and unsure of the code,
If( ColumnChart1 = 10, green, red )
^ this does not work, any help is appreciated!
Hi @molly1,
Do you want to set each item differents colors based on its value?
Actually, colors for column chart has a property named itemcolorset, which is providing a table of colors for all the items by order.
Eg, we set a table of color values like [Green,Red], each item will display as green, red per group as two by order. Like that if we have 5 items in column chart, it will display as green, red, green, red, green.
So, there is no way to set each item display different color based on its value.
Share
Report
All responses (
Answers (
382
