Right click chart or Chart tools Design tab Select Data Hidden and Empty
Cells (button in lower left of dialog).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jonathan" wrote in message
...
Hi, using Excel 2007 how do I plot a line through points with no data? At
the
moment there are gaps.

Many thanks,
Jonathan