Excel 2010 Graph Axis incorrect
Hi Experts,
I am new to 2010 and can't figure out why my date axis won't conform to my actual data points. Excel keeps putting the date at the first of the month, however, my data points are at the end of the month. I keep playing with the axis formatting and can't seem to get the axis to correspond to month end dates.
Thanks!
I am new to 2010 and can't figure out why my date axis won't conform to my actual data points. Excel keeps putting the date at the first of the month, however, my data points are at the end of the month. I keep playing with the axis formatting and can't seem to get the axis to correspond to month end dates.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
... nothing attached ....
ASKER
..oops, sorry...
Capture.JPG
Capture.JPG
A workbook would be more useful so we could see the settings and ranges in use ;)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Between the two answers I was able to fix it, but I had to start over, for some reason I couldn't seem to edit the original chart. Thanks!
ASKER