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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andy Pope" wrote in message
...
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rajula" wrote in message
...
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" wrote:

Hi,

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

Are the blank cells truly empty?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rajula" wrote in message
...

Hi,

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

Regards
Rajula