How a blank cell is treated in a Chart (Series)

[robbbo]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a chart that is 2x16 cells. One row is a series of dates the next is numbers. I plot the data in a chart with y=Dates and x=numbers. The chart looks fine. When I remove the data from both rows as to only the first 10 columns the chart automatically plots only the first 10 columns. This is the behavior I am looking for, but if these cells are linked to other cells that are blank such as =C5 and C5 is a blank cell the chart plots that data point as a zero rather than as a blank.

Does anyone know how to get the cell to be treated like a blank cell so the chart only plots cells that have real numbers in them?

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
I have a chart that is 2x16 cells. One row is a series of dates the next
is numbers. I plot the data in a chart with y=Dates and x=numbers. The
chart looks fine. When I remove the data from both rows as to only the
first 10 columns the chart automatically plots only the first 10
columns. This is the behavior I am looking for, but if these cells are
linked to other cells that are blank such as =C5 and C5 is a blank cell
the chart plots that data point as a zero rather than as a blank.

Does anyone know how to get the cell to be treated like a blank cell so
the chart only plots cells that have real numbers in them?

Make sure the cell's value is #NA() instead of blank. You can use the
formula =na() to produce this result.