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

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 toolsoptionschart 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

jaweiss wrote:

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 toolsoptionschart the default is not to plot blanks,
but because the cells are not blank, they show as zeros.