y axes not showing in percent (using Dual)

[Anonymous]

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

[prat1507]

Hi

PFA the desired app.

Regards
Pratyush

[Anonymous]

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

[Anil_Babu_Samineni]

Are you going to have this?

[Anonymous]

no here too the legend is not on the line, have a look on the right (the names)

[tresesco]

Would putting % on the data points be an option? Like:

[Anonymous]

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

[sunny_talwar · Accepted solution]

Is this what you are after?

[Anonymous]

yes, still trying to understand how you did

[sunny_talwar]

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