Problem in fixing month values in X-axis while preparing excel chart

[joy3939]

Hi,
I am preapring an excel chart where as the x axis valus I am taking month values seperated by 3 months starting feb-14, ie. values for feb-14, may-14, aug-14 and so on.

But, when i am selecting the range of values the chart is displaying missing values for months of mar-14, apr-14,jun-14 etc.

Pls guide me as to where i am making a mistake.
Thnx in advance...

[[email protected]]

Please attache sample excel sheet.


Regards,
Suhas

[Andy Pope]

Set axis to Text rather than Date or Automatic