The cells are blank, but the interpolate option is grayed out and cannot be
selected.

"Jon Peltier" wrote:

If the cells between the values for the line series are blank, go to Tools
menu Options Chart tab, and choose Interpolate for Treat Blank Cells
As...

If the cells are formulas returning "", change "" to NA(). This puts an ugly
#N/A error in the sheet, but the chart automatically interpolates across
these errors without showing them.

- 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
_______

"Scott" wrote in message
...
I have a chart that has one clustered column and two stacked columns.
Looks
great. I tried to format another set of data to be a line with markers.
All
I see is the markers, no line. Any ideas if this is possible?