Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that has to do with ranking and want the lower values (higher rank) to display at the top rather than at the bottom. So the work around was to multiply everything by -1 and make them appear as positive values on the data points using Number formatting
#,##0 to #,##0;#,##0. The problem is that the formatting only worked on the values on data points but I also want to show the axis and grid rather than hiding it, but the number formatting did not work on the axis.
Is there any way I can get rid of the negative sign on the Axis?
John,
use Fabs function instead of multiplying by -1.
fabs( -3.8 ) | Returns 3.8 |
-Siva