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

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