I managed to get this working again. I found a field inside Vertical Axis Settings > View Window that hadn’t been set to zero.
This is what was causing the charts to look as if they were not displaying the data correctly. In actual fact they were – but because I don’t display the Axis numbers I couldn’t tell