Synchronize Left & Right Axes in Bar/Line Charts
It is possible to sync the scale of the right axis to the left axis in bar/line charts.
Syncing the axes is done in Edit mode.
Click on the right axis, then click on the Manual Axis Range icon in the toolbox (the last icon)

Turn on the
Link with Primary Axis slider control to synchronize the right axis with the left axis.