cannot check interpolate

[Tarra]

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

 

[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

 

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

 

[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