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