View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
stine_white stine_white is offline
external usenet poster
 
Posts: 2
Default interpolating blank cells

I want to graph the data from a table, but I want the charts to interpolate
the lines inbetween the "blank" cells. All of the cells have formulas in
them because they are pulling the data from another worksheet, but some of
them appear blank because there is no data for that time slot. I have tried
the Tools:Options:Charts: Interpolate blank cells, but I can't get it to
work. Please help. Thanks.