Given the following data and chart:
Why is the chart displayed from right to left and how do I change it to appear from left to right?
Go to the Layout tab under Chart Options > Axes > Horizontal Axis > More options:
Then in the dialog, uncheck
(I initially had it the correct way round before checking this option)