how to make a #n/a amount not displayed in a chart

**sbirdsall** · 01-18-2010, 12:49 AM

In a line chart Im doing I want a zeros to not be displayed.

In one of the series of the chart i have this formula: =IF(D3=0,#N/A,D$2/D$3) so that #N/A is shown instead of #div/0 but this causes the chart to display a line that continues to the next axis point but this doesn't suit the purpose of the chart. It needs to just show a gap in the line.

If anyone has an solution for this please help, much appreciated.

Thanks!

**teylyn** · 01-18-2010, 01:24 AM

Hi,

In XL2003 click the chart, then Tools - Options - Chart and tick Gaps in the top section.
In XL2007 click the chart, then click "Select Data" on the Design ribbon, then "Hidden and empty cells" and select or "Gaps"

hth

**sbirdsall** · 01-18-2010, 02:03 AM

Thanks but it still isnt showing gaps. is it because theres a formula in the cell?

ive attached spreadsheet. Its the top graph and the cell im talking about is D5