Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
exclude blank cells in a line graph
I've seen some good threads to exclude blank cells from an excel line graph
by using NA()) instead of "". However, how do I accomodate cells that could = 0? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
exclude blank cells in a line graph
If the zero comes from a formula then modify the formula
So if the formula is =A2-B2 then use =IF(A2-B2=0,NA(),A2-B2) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Whitehorn" wrote in message ... I've seen some good threads to exclude blank cells from an excel line graph by using NA()) instead of "". However, how do I accomodate cells that could = 0? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
exclude blank cells in a line graph
Thanks. I'm looking to graph all calculated data that are currently
available (including 0) and ignore future calculations that will take place in subsequent weeks. "Bernard Liengme" wrote: If the zero comes from a formula then modify the formula So if the formula is =A2-B2 then use =IF(A2-B2=0,NA(),A2-B2) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Whitehorn" wrote in message ... I've seen some good threads to exclude blank cells from an excel line graph by using NA()) instead of "". However, how do I accomodate cells that could = 0? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Graph After Hiding Cells | Excel Discussion (Misc queries) | |||
Blank cells in graph | Charts and Charting in Excel | |||
How do I leave out blank cells in a line graph? | Charts and Charting in Excel | |||
Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
Blank line in cells | Excel Discussion (Misc queries) |