Line and Clustered column chart – two Y axis

[candrea]

Hi,
I have a Line and Clustered column chart and using the two Y axis BUT the line is too close to the column! and I don´t know how can I separate them!

I know how to change the scales, but if I do this the start and end numbers will gonna be fixed, impacting the view of the others categories of the slicer!

(I tried Label Density but it didn't work, it's not enough) 

Carol

Can you help me please?

Thanks,

[v-caliao-msft · Accepted solution]

@candrea

Based on my research, currently there is no available way to separate the Line and the column in addition to specify the Start and end of the Y-Axis, , if the data on both Y-Axis stay on the same data type and data range.

It's recommended to add the two shipments both under the column values, so that this would make it much more clear based on the same Y-Axis.

To better use the second Y-axis, it is recommended to add extra data which can’t be rightly calculated by the current Y-Axis.

If you would like to analyze the ratio of shipments, then opening the second Y-Axis and put the ratio value under the line value. Which would make the chart much more efficient.

In addition, check the article below for more reference regarding X-axis and Y-axis: 

Tutorial: Customize X-axis and Y-axis properties 

Regards,
Charlie Liao

[candrea]

Thank you so much!

I´ll try another graph

Hugs, 

Carol