Forum Discussion
Problem with Chart Axis in Excel
My chart axis shows only every other date, rather than every consecutive date that I want.
Please double click on axis to format it and check the units. If 2 days change on 1 day.
That was the first thing I checked. Major Units is set at 1 day.
And axis is not text? can you apply custom format to dates in axis formatting?
Axis is date, but I've tried changing it just to see what would happen, but it didn't seem to make a difference. I don't know what custom format I'd choose that would affect which dates are displayed.
Frustrating thing is I got it to correct in one chart by correcting the 'Bounds' dates. Problem is, that didn't correct in any other chart. Even tried saving the corrected chart as a template but it didn't correct the other charts.
