Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to display numbers with zeros in front of them, eg 005 | Excel Discussion (Misc queries) | |||
How can I display negative numbers as zeros? | Excel Discussion (Misc queries) | |||
How do I get excel to display zeros at the end of my decimals? | Excel Discussion (Misc queries) | |||
How do I import data and display zeros? | Excel Worksheet Functions | |||
Display Binary Leading Zeros | Excel Discussion (Misc queries) |