| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to ignore zero values when plotting a graph
Using Excel 2003. I have a data range for a graph. The values in the cells
are the results of a simple If function - If(m280,n28,0). The results are taken from a larger data input exercise. But, the graph line (a simple graph!) plots the FALSE value (0) when I would like there to really be no value & hence no plotted point if the result is FALSE. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with a scatter graph of conditioned values | Charts and Charting in Excel | |||
| How can i make values appear at the top of bars in a bar graph? | Charts and Charting in Excel | |||
| Graph values in ascending order | Excel Discussion (Misc queries) | |||
| Bar graph values keep changing | Charts and Charting in Excel | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Threaded Mode
