In an MS Excel chart I would like to display positive values as green bars/lines and negative values in red. I am able to get the positive values in green, but the negative values still display in the default grey. How can I get the chart to display the way I want?
Is there any way to get line graph segments ( between any two values) to display in a color different from the rest of the line?
Is there any way to get line graph segments ( between any two values) to display in a color different from the rest of the line?