Hide one month in a chart

[dkbleechmore]

I have data from July 2006 to January 2007 that I need to chart. The
only catch is that there is no data for Dec 06 (we do not capture this
data due to the Xmas rush).

On the chart I would like to remove Dec 06 but have not succeeded. Any
ideas?

 

[Bernard Liengme]

In the cell where the Dec 6 data should go type =NA()
This will display as #N/A
Excel will ignore it when it charts
But Dec 6 will still be on the x-axis (it would be misleading to not have
it)
best wishes

 

[Don Guillett]

Hide the row?