A third option, if the cells appear blank because a formula returns "",
change "" to NA() in the formula. The cell contains the #N/A error, but
the points will be connected by the line.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
ET wrote:
Jon,
For the monthly data; spacing it evenly over 26 bi-monthly pay periods means
a blank cell about every other cell. When this happens I cannot connect the
data points with a line. Anyway to get around this?