Zeros Display On Chart

E

Ed O'Brien

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Lines 2
setting scale on chart automatically 1
Display empty cells as gaps, zero, or connect in chart 1
Unwanted Zeros in Excel Chart Displayed Values 4
Chart display of no value cells 1
Display Ticket Numbers in Other sheet based on condion 1
Combination Chart 1
How to display 2 pieces of data on one bar of a Pivot Chart? 1

Top