Scatter chart. Change Horizontal Axis Labels

[MrKCL]

Hi everyone,

Hope this question hasn't been asked before, if so apologies.

I'm working on a scatter chart but having trouble with the X-axis labels. I want to have sequential dates running along the bottom of the X-axis, but no matter what I do it's labelled with even-numbers.
I'm using a scatter chart because the data I'm using, social surveys, was recorded irregularly over the course of 2018.

Thank you!!!

 

[DSCfromCFA]

G'day KCL

Are you able to give provide a sample of your row and column headings plus a bit of data - doesnt have to be real, just your layout, so we can try and replicate the matter.

Cheers

shane