Ask Your Question

Multi Colour 3D Bar Chart representing positive or negative values

asked 2021-01-02 12:21:30 +0100

White Knight gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-02 13:31:59 +0100

Opaque gravatar image

updated 2021-01-02 13:37:52 +0100


the only way I can imagine is to use two helpers columns splitting positive and negative values into separate data series - see the following sample file


image description

Remark You may need to adapt the legend.

edit flag offensive delete link more


Unless you used Photoshop that looks like the solution to me. I will need to adjust my own data sources to facilitate the change but I don't see any real problems there. Thanks for your inspiration.

White Knight gravatar imageWhite Knight ( 2021-01-02 14:08:55 +0100 )edit

Unless you used Photoshop...

My sample file proves the contrary ;-)

Opaque gravatar imageOpaque ( 2021-01-02 14:12:42 +0100 )edit

Confirmed, no Photoshop, worked like a charm. I definitely learned something new today - Dankeschön.

White Knight gravatar imageWhite Knight ( 2021-01-02 15:18:32 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-02 12:21:30 +0100

Seen: 31 times

Last updated: Jan 02