| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 1195 | 1999-04-06 01:00:00 | Empty Cells in Excel - Graphing | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1547 | 1999-04-06 01:00:00 | Re Bob Heron's problem in the April Issue. I had the same problem with Sales Graphs and found that if you create an IF statement in the graph data series range that returns #N/A, the problem is solved. Excel for some reason treats this as a 0 and your graphs no longer have gaps. For example IF(A1+B1=0,#N/A,A1+B1) |
Guest (0) | ||
| 1 | |||||