Average Rate on Combo chart

[kavitha_kommise]

Hello Everyone,

I have a requirement like to represent  average rate on combo chart using line.

In one left axis i am showing count and right axis amount using some dimension fields.

Now my average rate will

Amount/Count=Average rate,using line

Now problem is My charge in billion and count in million

so my average will be very less to show...

i want to show trend line for average....but what ever i am calculating it will always gives line in bottom only...because two axis having big value............

how can i represent this in best way ...

what would be the better to show..

Please help on same..

Thanks in advance,

Kavitha

[Gysbert_Wassenaar]

Use separate charts for each measure.

[kavitha_kommise]

can it possible to show in same chart?

Thanks and regards,

kavitha

[Gysbert_Wassenaar]

Nope. A chart can only have two scales. And the second one is always one too many too imho.