Forum Discussion
Regular ticks for X-axis when data is irregular
OraMcCreary My guess is that some or all of your "dates" are really text. In the attached is an example showing how it will automatically use dates (note: the x axis is actually in days with the x-axis number format set to date. This is why the tick marks are not like 2/1/19, 4/1/19, 6/1/19 but instead actual even intervals based on # of days)
Since you haven't attached a sample file I would just recommend checking the date column to make sure all those values are actually dates. I hope that helps.
You're right.
I just looked closely at the date column. One of the dates was ".7/1/19" - which of course is text. I had to look carefully at all the values, and didn't notice that one it till I looked closely.
Another funny date was more difficult. My date column had several dates looking like this:
2-Dec-19
4-Dec-19
5-Dec-19
I looked carefully at the underlying values and discovered this
12/2/2019
12/4/2119 <-- !!
12/5/2019
That stray date in the next century made for a funny-looking chart!
You've been very helpful. I still have some fiddling to see if I can get exactly the format I want, but you gave me the clue to fix the main problem. Thank you!