Graphing blank cells as gaps
 

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 displaydata
labelsvalues 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

Graphing blank cells as gaps
 

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


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111487