I am using Excel 2007. I have made charts that have dates as the x-axis and numerical (cummulative) values for the y axis.
The lines go up as they should, but the dates don't line up properly. They y-value lines up with 4 months before it actually happened.
I have added more dates and values after initially creating the chart. The plot area updates, but the x-axis doesn't. I have tried changing the distance between tick marks, intervals for the dates showing, making the chart bigger and smaller, selecting the date data range, etc. I am out of ideas for how to make them match.
Any help would be greatly appreciated!
Bookmarks