Charting blanks as spaces
 

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

Charting blanks as spaces
 

something like =if(D3="",DISPLAY NULL VALUE,D5-D3)

what can i put in there to make it a null value

"Todd" wrote:

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

Charting blanks as spaces
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Todd" wrote:

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