Prevent non-numerical data (e.g. text) from plotting on a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to chart a series of cells. Depending on the assumptions, the data
will either be numbers or text. I only want the chart to plot the numbers.
Currently, the chart keeps plotting the text as zeros. Is there any way to
prevent the chart from displaying these as zeros (in other words, not plot
them at all)? Under tools>options>chart the default is not to plot blanks,
but because the cells are not blank, they show as zeros.
 
There is no such option. You can plot a helper column instead that has
the formula
=IF(ISNUMBER(dataRange),dataRange,NA())

Jerry
 
Back
Top