Charting Month Year at together

[arnab0711]

Hi,
I want to make a chart which has Mar'12,Mar'13,April'13,May'13 figures,but when I create the chart its showing all month from Mar'12 -Mar'13 together,and not just these 4 months,please advice.attached excel sheet

[p45cal]

I made the adjustment to the x-axis from automatic to text in excel 2010 compatibility mode with earlier versions, so I hope it sticks.

In excel 2003, you right-click the chart, choose Chart options.., then in the Axes tab, click the Category option button instead of the Automatic one being active.