Forum Discussion
Custom Number Format Line Chart Y Axis
Hi all,
Is it possible to get a custom number format on the Y Axis?
I formatted for thousands, but now zero shows as 0.0K, I would prefer a "-" for zero.
Thanks,
-w
Hi,
Not sure if there is any solution, where the Y Axis format is as a number(decimal), but the "-" is char type.
if you don't want to show the 0.0 value, then you could change the Minimum Range of the Y-Axis and start it > 0
Appreciate your Kudos and please mark it as a solution
2 Replies
Hi,
Not sure if there is any solution, where the Y Axis format is as a number(decimal), but the "-" is char type.
if you don't want to show the 0.0 value, then you could change the Minimum Range of the Y-Axis and start it > 0
Appreciate your Kudos and please mark it as a solution
Line/clustered column/bar charts require a numerical value for the values to be displayed. If you change 0 to "-" it will become text
