NeverHappyMike
Member
Hi
I was reading, and now implementing, the article about improving in-cell charts with negative values. I've run in to a problem.
When I apply the formula used in the downloadable sheet, it does not show up my small % values. I've therefore tested with some other % values and only begin to see the bar appear when I get near +/- 200% (or above/below).
What do I need to do to this formula to make values like -4.65%; 6%, 19%; -16% appear?
=IF($W3>0,REPT($Y$2,ROUND($W3/2,1)),REPT($Y$2,ROUND(-$W3/2,1)))
Any pointers/advice greatly appreciated.
Michael.
P.S. I had originally posted this question at the bottom of the original post, but realised later that it might not be the best place to do it. Apologies for the double posting.
I was reading, and now implementing, the article about improving in-cell charts with negative values. I've run in to a problem.
When I apply the formula used in the downloadable sheet, it does not show up my small % values. I've therefore tested with some other % values and only begin to see the bar appear when I get near +/- 200% (or above/below).
What do I need to do to this formula to make values like -4.65%; 6%, 19%; -16% appear?
=IF($W3>0,REPT($Y$2,ROUND($W3/2,1)),REPT($Y$2,ROUND(-$W3/2,1)))
Any pointers/advice greatly appreciated.
Michael.
P.S. I had originally posted this question at the bottom of the original post, but realised later that it might not be the best place to do it. Apologies for the double posting.