Sync/link Y axes of two different charts

[Anonymous]

I have two charts side by side. They show two different (but not very different) things and I would like the Y axes to use the same scale i.e. start, end and space between grid lines. Is there a way to "sync" / "link" the axes of these two charts? Thanks

[v-yuezhe-msft]

@Anonymous,

You can manually set start and End values of Y-axis for the two charts.



Regards,
Lydia

[Anonymous]

@v-yuezhe-msft

Thanks Lydia! In fact I have a dropdown menu slicer that will change the lines on the charts. I would like the axes scales to adjust automatically (as per the default axis settings) but I would like both charts to adjust to the scale to the same start/end and gridline interspace. Is that possible? If it is not possible, is there a convenient workaround?

[v-yuezhe-msft · Accepted solution]

@Anonymous,

I am afraid that it is not possible to change the start&end values based on slicer selection. You would need to manually adjust the values.

Regards,
Lydia

[Anonymous]

@v-yuezhe-msft

Thanks Lydia, that is what I suspected. Perhaps a workaround is adding an additional series to both charts, with the max and the min values, in white so that it is not seen. I might try that if I get a chance although it would not be an ideal solution, just a workaround.