View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dave
 
Posts: n/a
Default Time on the X Axis Issue

Posted this on Excel - no response. Guess I should have been here.

I am trying to plot events on a time abscissa. I would like to have the
major gridlines at even times, such as 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM
etc. My data, however, occasionally falls in between these times, i.e.,
8:05 AM, 9:17 Am, etc.

When these points are plotted (correctly), an extra vertical gridline
appears automatically at the correct data time. My problem is I don't want
that data point gridline to appear.

Is there any way I can opt not to get the extra line??
Thx
Dave