View Single Post
  #1   Report Post  
Phil Rowe
 
Posts: n/a
Default I want to ignore invalid values in scatter chart

I have an x-y scatter chart which uses values calculated from other sheets in
the workbook. Sometimes these values are invalid, and therefore I use "IF"
to render the appropriate cell blank. The entire series then disappears from
the chart. I just want that point to bu uncharted. Any ideas?