How to separate stacked bar and line chart divergence point when both values is equal to 1

[Raymond_Halim]

Hello all,

I am developing a dashboard and I found out both my stacked bar (unit in %) and my line chart (in whole number values) has a datapoint where both stacked bar and line chart value both equals to 1.

How do I try to show my line chart (whole number) so that the line stays above the stacked bar?

Thank you in advance and much appreciated for your help!

Ray

[FreemanZ]

hi @Raymond_Halim 

try to plot the line chart with a second Y-axis. 

[Raymond_Halim]

Hi @FreemanZ 

Is there a way that when I am using a second Y-axis to plot the line chart the line chart will always stay on top of the chart?

[FreemanZ · Accepted solution]

hi @Raymond_Halim 

yes, you can do it via setting the min of Y-axis. 

The smaller of the min, the higher of the line.

[Raymond_Halim]

Thank you @FreemanZ. Now I can get this set-up per business need!

Ray