Log In
Register
Home
Active Member
Dashboards
Advanced Excel Formulas
August 14, 2019
Offline
Hello guys,
I am struggling with a chart and I really hope you can help me 🙂
I would like to create a treemap which would display positive and negative value.
I have figured out (but I might be wrong) that the only issue would be to have 3 differents columns : one with the description, one with the absolute value and one with the information if the value was initially positive or negative.
Now, what I don't know is how to affect a color panel to the negative (let's say the reddish ones) and a color panel to the positive values (blue ones).
I join a file and hope someone can figure it out 🙂
July 16, 2010
Offline
Hi Nicolas,
Unfortunately there's no way to specify a separate colour scale for the negative and positive values. You'd need to do this manually by selecting one item at a time in the chart and then setting the colour.
Mynda
1 Guest(s)
