A rather simple question that has wasted a lot of my time since yesterday. Following data:
10/10/2010 9:30 1
10/10/2010 9:40 2
10/10/2010 9:50 3
10/10/2010 10:00 4
10/10/2010 10:10 5
10/10/2010 10:20 6

When I do line plot, excel plots all the x-values on a single point (ignores time)

When I do scatter plot, excel understands the time but sets the axes start and end points very wide starting from 00:00:00 and intervals on its own terms. This doesn't work for me as I don't want to change auto settings as data is variable.

When I change formatting to just time, it works but doesn't help me as my date spans dates.

I am sure lot of people out there have done plotting against date time. Please help me with exactly what I need to do in order to make this work. Plotting should not be so hard.

thanks a lot