Simple table with values that correspond to a calendar date.

But, excel is showing the x-axis (the dates) at intervals (whatever I put in doesn't work) that skips the dates in the table.

If I set the units to "1" I get every day of the month, but I'd rather not have it that cluttered, nor make the chart so big to see it all.

I'd rather have tick marks for each day of the month but have a major mark for the dates in column a.

Column A is dates (5/6, 5/17, 5/21, 6/3, etc)
Column B is the data.


There used to be a nice chart add-on that would allow this sort of thing, unless I'm missing a new feature of excel.