I have an 3D MSChart(Line chart) with an x y and z axis. The values on my Y axis(vertical axis) range from 0 to 100 and the values on my X axis and Z axis also range from 0 to 100. The color of my line is red for the whole column but I want to be able to change it depending on the value on my Y axis. For example, if i have a value in the range of 0 - 20 on my Y axis I want to change the color of the bar to red, and if the value of my Y axis is from 20 - 40 I want the color of the bar to be green, etc.
Can anyone help me with this?