Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
wanting to NOT plot #Div/0 on chart
Good afternoon,
I have serveral charts that plot #div/0 as zeros. My current function is simple (=sum(D3+G3)/C3), which returns the #div/0 in the reports containing the chart info. Is there a formula I could use (NA? possibly) that would take care of this problem? Thank you! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
wanting to NOT plot #Div/0 on chart
Asking 3 times in no more likely (in fact probably less likely) to give you
an answer than asking once. -- David Biddulph Brandy wrote: Good afternoon, I have serveral charts that plot #div/0 as zeros. My current function is simple (=sum(D3+G3)/C3), which returns the #div/0 in the reports containing the chart info. Is there a formula I could use (NA? possibly) that would take care of this problem? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
dot plot chart+chart wizard | Charts and Charting in Excel | |||
how to plot a polar chart / plot | Charts and Charting in Excel | |||
Excel chart : I want to plot on the same chart bar and line | Charts and Charting in Excel | |||
Wanting to know if this is possible | Excel Discussion (Misc queries) |