Interpolate is disabled

  • Thread starter Thread starter Rajula
  • Start date Start date
R

Rajula

Hi,

The interpolate option is disabled. How do i enable it?
There is lot of gaps with for cells with blank.

Regards
Rajula
 
Hi,

Do you have a chart selected when using Tools > Options > Charts > Plot
empty cells as?

Are the blank cells truly empty?

Cheers
Andy
 
Yes, i do have the Plot empty cells as, only - Not Plotted (leave gaps) &
Zero are enabled. And Interpolated is disabled.

My data is something like this.
x y x k l m
a 1.00
b 1.00
c 1.00
d 1.00
e 0.50 0.50
f 1.00
g 1.00
h 1.00
 
So what chart type do you have? Column charts are discreet values.
Interpolation will only be available to line, xy-scatter, area, radar,
surface.

For column you would need to calculate the value based on the actual data
points either side.

Cheers
Andy
 
Hi Andy,

Oh Ok, i have a column chart.
So how do i get rid og the gaps in a column chart. But thanks for all the
replies.

Regards
Rajula
 
Simplest way is to hide the rows and make sure the option to Plot visible
cells only is applied.
You may be able to use Autofilter to make hiding the rows easier.

Cheers
Andy
 
Back
Top