Graphing blank cells as gaps

[Todd]

I know you can chart blank cells as spaces by clicking it in the
options...this is a little different.

The cell it is charting as an if function in it to display a blank cell.
example:

=if(D3="","",D5-D3)

So when D3 is blank it should display in cell D6 a blank. But when it charts
it, it charts it as a zero. I want it to chart it as a gap.

I tried =if(D3="",NA(),D5-D3), This way i get a "#N/A" error in my cell,
which i can hide through conditional formating. but when i click display>data
labels>values in chart options it displays "#N/A" instead of a gap.

I need to somehow display a gap.

Please help


maybe something like:

=if(D3="", DISPLAY NULL VALUE,D5-D3) to display somekind of null value

 

[jamescox]

Might get more help on this if you would delete it from this forum and
move it over to the Excel Charting forum...