Formatting year and day on x-axis

I have problem to present the right year and date on my chart. When I plot the chart everything is fine and shows the data, but year is 1900. If I correct axis option-minimum and maximum to shows the right day and year-data disappears from chart. Attached is sheet if anyone want to look.

Hi, the problem is your dates are stored as text, rather than date values. Convert them using something like:
=--A1
in D1 and copy down, then paste the values over the values in A1.

I've attached an example.

ragulduy, thanks a lot. Second week I'm suffering with this problem.

Date format is not readable in excel, create one more column and make that date in "mmm dd yy" format.

Regards,
Suhas