Hi,

I've got dates on A1:E5 in mmm-yy format, with each subsequent column increasing by one year. ie) Dec-09, Dec-10, Dec-11, etc

I've created a line chart with the X axis data linking to A1:E1. The problem is that on the chart, the dates show up as Jan-09, Jan-10, Jan-11, etc.

Has anyone come across this issue before? I'm not sure why the wrong date appears.

Thanks in advance.