Is there a way to set colour-fill limits at different points along the Y- axis of a bar chart, so that my bars will be coloured in proportionally to those limits? (ie. on Y-axis I want 0-200 to always show up as white, 201-400 to always show up as green, 401-600 to always to show up as black across my entire data set. So if I have data that has a value of 600, it will be coloured in 1/3 white, 1/3 green, 1/3 black. If I have data that has a value of 400, it will be coloured in 1/2white and 1/2 green only? If I have data that has a value of 200, it will only be coloured in white?
THanks!
Bookmarks