Forum Discussion
Problem with Chart Axis in Excel
My chart axis shows only every other date, rather than every consecutive date that I want.
If all the dates in your data set are not being reflected in axis, you should try to increase the width of the chart.
Subodh_Tiwari_sktneer yeah, I thought about the width, but that didn't affect it. Neither is it the number of units in the Format Axis window. the Major Units is set to 1 day. I'm still stumped.
What if you change the axis type to Text axis?
Also, right click the chart and choose Select Data and in there make sure that the horizontal axis is correctly set for all the series, if not, edit the horizontal axis for each series in the chart to use data in date column.
Subodh_Tiwari_sktneer date series is properly selected.
I appreciate the effort of the Community to help me out, but I really can't believe how inept MS support is. It's f-ing ridiculous.
