|
Interpolate is disabled
Hi, The interpolate option is disabled. How do i enable it? There is lot of gaps with for cells with blank. Regards Rajula |
Interpolate is disabled
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 |
Interpolate is disabled
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 |
Interpolate is disabled
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 |
Interpolate is disabled
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 |
Interpolate is disabled
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 |
| All times are GMT +1. The time now is 08:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com