Advanced Excel Formulas
August 14, 2019
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