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