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