Two ways:

1. Make the chart as a line chart, choose the Interpolate behavior, then
change the other series to a column type.

2. Put #N/A into the blank cells in the line chart's source data, which will
make Excel interpolate across the gap.

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


"Tarra" wrote in message
...
thanks John, it is a combinmed line and bar chart and the data set i am
trying to interpoolate is graphed as a line - any suggestions?

"Jon Peltier" wrote:

This setting is available only for line and XY charts. (It's also
available
for Area charts, but does not cause interpolation of the data).

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


"Tarra" wrote in message
...
tool - options - chart cannot check interpolate so the missing data
between
my data set interpolates to value