Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Do not show blank cells as 0 in chart
I have a spreadsheet with a two columns, one for expected enrolment numbers
and the first column of actual enrolments. For April we expect 90, so have a blank cell to the right for actual. This is showing a line from the March enrolment of 3 down to 0. How do I get the line to stop at 3 until I put a figure in for April? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
Activating a Chart object | Charts and Charting in Excel | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) |