View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
mrgou[_2_] mrgou[_2_] is offline
external usenet poster
 
Posts: 4
Default Date/Time on X axis

Hi,

As I'm moving from Excel 2003 to 2010, I'm struggling with a simple
graph. I want to plot measures over time, where each measure is made
at a specific date and time:


Date/Time |Ser1 |Ser2 |Ser3
20/06/2011 20:34 |23 |412 |21
21/06/2011 07:22 |441 |414 |535
21/06/2011 19:18 |52 |525 |525
21/06/2011 21:06 |646 |7 |7453
22/06/2011 07:00 |65 |5645 |5445
22/06/2011 18:32 |8789 |889 |45
22/06/2011 21:18 |67 |65 |765
23/06/2011 06:44 |123 |84 |65

The chart I get from the wizard only keeps one entry in the X axis per
day, discounting the exact time. How can I force to keep the data/hour/
minute units on my X axis?

Thanks!

mrgou