View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
maryj maryj is offline
external usenet poster
 
Posts: 76
Default xy scatter with date/time as x axis

I have an XY Scatter chart with date/time values along the x axis.

For example, 5/1/07 8:00 am, 5/1/07 2:00 pm and 5/2/07 10:00 am.
I want an XY Scatter to properly show the time increments. Is there a way to
have the x axis only display the actual dates and times rather than showing
values of equal increments? I have gone into the axis options and have
adjusted the scale but it is difficult to know the exact times. Or do I need
to resort to data labels or textboxes?

Thank you!

--
maryj