cannot check interpolate

T

Tarra

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

Jon Peltier

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
 
T

Tarra

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?
 
J

Jon Peltier

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
 
Top