I've got a line chart with 3 data series. One has much larger values than the others so I've put it on the secondary y-axis. However, when I do this it messes up the y-axis category labels. They are supposed to be dates running from 1st April 2020 to end of June 2020, but when I add the secondary y-axis they change and start from 1st January 1900! The chart is supposedly still looking at the same range for the labels but isn't reading the correct ones in once I put the secondary axis on.
Does anyone know how to fix this?
TIA :-)
Bookmarks