Line & Clustured Column Chart using 2 Line values with different Y-Axis

[budsal]

Hi

I'm trying to create visualisation with Line & Clustured Column Chart, the data are sales, target & ratio(sales/target). I'm trying to assign sales to column chart, and then target & ratio as line chart (2 lines). The problem with this is the ratio line will be flat out, since the right Y-Axis is using the target line scale (billion).

Is there any way to set the line chart to use column axis, the left Y-Axis, since in this sample the target and sales are the same scale, then the right Y-Axis will be the percentage scale of the ratio.

Thanks 

[v-yuezhe-msft · Accepted solution]

@budsal,

There is no method to set the Line chart of only Budget filed to use scale of left Y-Axis unless you drag the Budget field into Column Values section. In the combo chart, fields in Line Values use same scale.


In your scenario, change the scale type of Y-Axis(Line) to "Log" and check if the ratio line appears.


Regards,
Lydia

[budsal]

Ou ok, I see.

Yes when i change to Log, it looks better

Thanks