cannot check interpolate
 

tool - options - chart cannot check interpolate so the missing data between
my data set interpolates to value

cannot check interpolate
 

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

cannot check interpolate
 

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

cannot check interpolate
 

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