Linked X-axis or Y-axis

Sometimes you have two or more charts on a sheet, and you use these chart to compare with each other. However, if the metrics differ in magnitude (y-axis), or one has missing values on certain data point (x-axis) then the charts are misaligned or difficult to visually compare A possible idea would be to created shared/linked axes, where you can link two or more charts axes, so that both charts show the same upper and lower amount (y-axis) or both charts show the same data points (x-axis) even there is missing points in one of them. Thanks,
Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes