Zeros Display On Chart
 

Excel 2007

I have an Excel sheet containing a chart that records daily alcohol
consumption. The information for the chart is related to data (entered vis a
simple formula) contained in a cell for each day of the month. This column
of cell forms the chart Series.

To avoid the display of zeros in the zero value cells I have unchecked the
appropiate box in Options/Advanced/Display. However, I do not know how to
get rid of the line of zeros cluttering the botttom line of the chart when
no data has yet been entered.

Can anyone help with this?

TIA,

Ed