Help Block Automatic Changes in Chart Axis Scales

I have numerous charts in my spreadsheets in which the x-axis scale type needs to be Date. However, if I change the chart's range, the type automatically changes to Text. How can I prevent LO from doing this?

TIA, Jonathan