Hide one month in a chart

  • Thread starter Thread starter dkbleechmore
  • Start date Start date
D

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?
 
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
 
Back
Top