Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
One of the charts to be created has its Y-axis in a descending order.
I read in earlier similar requirements, and the solution suggested was to multiply the Expression result by -1.
But, such soulution will negate the resulting values,distorting the resulting chart !
Also, in my below chart the Scale is from 9 and 1 ie. all Positive.
Any suggestions appreciated !
Cheers !
Multiply by -1 and then change the format of negative numbers to not include the - sign.
Under the number-tab select Integer and change the format pattern to: #,##0;#,##0