Excel plot against a date time x series closed

Question

Why does Excel ignore the time component of DateTime values in a chart? For example, the 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

excel plots all values on the same x-value 10/10/2010. If I format the values as time, it works fine. How do I tell excel to display DateTime and interpret it as DateTime, not date?

Answer 1

Try using an X-Y Scatter graph with DateTime formatted as YYYY-MM-DD HH:MM.

This provides a reasonable graph for me (using Excel 2010).