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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Omit points from plot if cell is formula returns a non-numeric res
Hi,
Charts plot all non numeric values as zero. There will however interpolate values if #N/A is used. =IF(G30,F5+G3,NA()) Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Dave" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Omit points from plot if cell is formula returns a non-numeric res
Dave,
If you use "NA()" similar to the formula below, Excel will interpolate values for the points that hit zero. =IF(G50,G5,NA()) If you want to break the line, Andy Pope has an example that shows how to do so on hit web site. www.andypope.info -- John Mansfield "Dave" wrote: 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. |
Reply |
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 |