Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
On the first i hope you can excuse my english because it's not my maternal language and maybe my question. I search a lot on community without response.
I create an age pyramid on a single chart who make a difference between man and women. For show the differences I make a man's numbers negative. I would like in my chart show this value positive.
I already try different number format without success.
Do you have an idea, a solution ?
Thanks for your help.
You could change it in Number formatting tab.For both positive and negative as same
#,###;#,###
Hi
Try like this
fabs() which converts negative to positive number
You could change it in Number formatting tab.For both positive and negative as same
#,###;#,###
For they other answer, if you use fabs() in your expression that's convert value before to show them and i would like only visualy.
Thanks a lot everybody.
no but fabs() can be used outside complete expression this is also for visual purpose.
you can use it like
fabs(sum(A)/Sum(B))... it will change - to + only after calculation of expression.
Regards,
Rajni,
I try on a graph to use it without sucess. It's transform value in positive value. My purpose, it's negative value stay a negative value but visually you saw a positive value.
Thanks,