Hello,
I'm wondering whether it is possible to change the number format of a chart axis depending on a data selection. Here is the use case:
an AppStudio report returns values which can get rather big. So I've added the possibility to select a scale (absolute, thousand, million). In case the user selects "million", I want the values to be displayed with one position after decimal point. In all other cases I don't want any positions after decimal point to be shown.
I can solve this rather easily in the cells which return the values by adding a conditional format. But when displaying the values in a chart, I have to select a number format for the y-axis. At the moment, the number format is #,##0 (so no position after decimal point). Is it possible to adapt this number format that it looks like #,##0.0 but only when the user selects "million", so that the y-axis of the chart is displayed in the same number format as the cells?
Best regards, Daniela
