Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I have y axes showing as percent
If I try to change format setting from the Number tab the dual function will not work anymore,
so guess need a solution within the Dual function,
=Dual(
If(MyDate=Max(total MyDate), Name, ''),
Sum ([Grade])/Max(Total Aggr(Sum([Grade]), [Name]))
)
Thanks
Raphael
Is this what you are after?
Hi
PFA the desired app.
Regards
Pratyush
No good
As I said:"If I try to change format setting from the Number tab the dual function will not work anymore,"
so in your solution we do not have the legend on the line of the Graph! but thanks for trying
Are you going to have this?
no here too the legend is not on the line, have a look on the right (the names)
Would putting % on the data points be an option? Like:
I have many observations , so do not want to show the percents on the line, but rather just the Legend at the end and the y axes as Percent
Is this what you are after?
yes, still trying to understand how you did
Created a second expression for putting the name
If you see for display option, Line is unchecked and only Values on Data Points is checked. This expression shows the name, while the first expression handles the axis and the line