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" wrote:

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