Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Omit points from plot if cell is formula returns a non-numeric res
How can I prevent cells with a non-numeric function result from being plotted
as zero values. The function =IF(G30,F5+G3,"") Plots values as it should for G0 but when G<=0 it plots points on the x-axis instead of omiting the points as it does when the cells are blank. On the spread sheet the cells display blank as they should. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I plot XYZ points in excel? | Charts and Charting in Excel | |||
How can i plot every 10 of my data points (i.e. 1, 11,21,.,10001) | Excel Discussion (Misc queries) | |||
Plot many X-Y points with each being labeled with an ID | Excel Discussion (Misc queries) | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
Plot points with same x-value in same series? | Charts and Charting in Excel |