I have a chart which, up until I entered the last row in the series was working fine. When I added the information for 31/8/12 (dd/mm/yy), the chart did two things. First of all it changed all the dates on the chart rendering to the first of the month, and second it extended the chart an addition 4 months which aren't in the series. Can anyone shed some light on why this might have happened? (Excel 2010, Windows 7).
I've attached a screen shot of the spreadsheet.
Thank you.
Bookmarks