Forum Discussion
Line & Clustured Column Chart using 2 Line values with different Y-Axis
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
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
2 Replies
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,
LydiaOu ok, I see.
Yes when i change to Log, it looks better
Thanks
