Interpolate is disabled

[Rajula]

Hi,

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

Regards
Rajula

 

[Andy Pope]

Hi,

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

Are the blank cells truly empty?

Cheers
Andy

 

[Rajula]

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

 

[Andy Pope]

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

 

[Rajula]

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

 

[Andy Pope]

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