cannot check interpolate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

tool - options - chart cannot check interpolate so the missing data between
my data set interpolates to value
 
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
 
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?
 
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
 
Back
Top