| 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) | |||
Threaded Mode
