Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
Hi All,
I found this spreadsheet on the net: http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg# It is a log for runners. The chart displays only the days that contain some data. Those are the days that a person did a run. I'm tried this on my own chart but it always comes up with the line dropping to zero value when no data was found on that day. How is this done? Regards Marco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA WHICH IGNORES POSITIVE VALUES | New Users to Excel | |||
Solver Ignores Constraints | Excel Discussion (Misc queries) | |||
How can I make my chart update the new values from database? | Charts and Charting in Excel | |||
Min Value using array ignores Zero | Excel Discussion (Misc queries) | |||
Autosum ignores cell values | Excel Worksheet Functions |