If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|