J
jain.samit
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
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