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

1. Use an XY chart, not a line chart.
2. Delete the gridlines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Dave" wrote in message
...
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