Multi Colour 3D Bar Chart representing positive or negative values
Hi there, I'm aware of the procedure for two colour representations when using stacked, 3D bar charts. As can be seen from the attached image, the two colours can definitely represent the "base" value and the "change" compared with the previous value. The data can even be structured to correctly position the variation above or below the "base" value depending upon whether the change is positive or negative. I would love to be able to represent a diminution in value with a red stack but even formatting the underlying data for red negatives doesn't change the colour rendition. The basic chart structure only permits the definition of two fixed colours. Is anybody aware of a manner in which the second colour may be varied according to whether it is positive or negative? Thanks in anticipation. C:\fakepath\MultiColour.png