Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have some difficulties with changing the labels of the y-axis in a chart. The function shown in this chart is a discret one, which means the function has either the value 0 or (-1). I would like to replace 0 with "abc" and -1 with "abcd" (for example). Does anybody have an idea how i can solve this problem?
Best regards,
Mila
On the y-axis? Or do you mean a scatter-chart?
Peter
Hi,
You can do something like:
IF (function=0,'abc','abcd')
Regards
If the values are always 0 or -1, then the scale can be fixed. At that point, you can just put text boxes on top of the numbers. It's a cheap trick, but I've done it before.
Its all about the y-axis of a line chart. 🙂
Hi,
where can i write the function into, so that the labels of the y-axis change?
If i write it into functions in the properties of the chart, it cannot be displayed, since this function has characters as a value.
Best regards
Mila
Hi,
Try putting the label you want in the Symbol field of the expression in the Number tab of the Chart Properties.
Hope this helps.
Regards,
-Karthik
Hi John,
thanks for this very nice(!) cheap trick. If i wont find any alternatives this will be my choice.
Best regards
Mila