Hide one month in a chart
 

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?

Hide one month in a chart
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
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?

Hide one month in a chart
 

Hide the row?

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
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?