Forum Discussion
Problem with Chart Axis in Excel
My chart axis shows only every other date, rather than every consecutive date that I want.
Not necessarily in answer to your issue but I started with your question looking for help with my own problem. In making a chart, I selected my data correctly and the chart appeared to display okay. But the x-axis was simple numbers rather than dates. I tried changing the axis to dates and whenever, I did the data disappeared from the chart. I tried everything I could think of and looked for help online but nothing worked. I finally examined the date data in my first column and noticed that one of my dates didn't quite line up with the other dates. I could not see what was causing the difference so I simply re-typed in the date and bingo! the chart displayed correctly. This drove me crazy for two days. Hope this helps someone else.