Charting blanks as spaces

[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

 

[Shane Devenshire]

Hi,

When I plot a chart with NA() and turn on Data Labels, everything looks good
here. What version of Excel are you using? I tried it in 2003 and 2007.