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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Bilinear interpolation 1
Excel 2007 - Interpolate 2
How do I bridge the gaps in data in (XL 2007) Area Chart 11
Maximum value for interpolation 4
Interpolation Add-in: XonGrid 3 release 0
interpolate 2
Interpolated charts 7
MS Excel does not interpolate empty cells 3

Back
Top