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
|
|||
|
|||
Chart ignoring formulas but only plotting formula results
I am creating a line chart where the source data is the result of an =IF
formula. How do I get the chart to only plot the cells where there is a result? Currently the chart is plotting a zero value for all the cells where the formula does not yet show a result. |
#2
|
|||
|
|||
Chart ignoring formulas but only plotting formula results
If( something, formula, NA() )
The otherwise blank cells now have #N/A in then (you can hide these with Conditional formatting if they bother you) Charts ignore these values best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JD" wrote in message ... I am creating a line chart where the source data is the result of an =IF formula. How do I get the chart to only plot the cells where there is a result? Currently the chart is plotting a zero value for all the cells where the formula does not yet show a result. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 06:18 PM |
Array formula returning wrong results | TUNGANA KURMA RAJU | General Discussion | 1 | November 19th, 2005 11:29 AM |
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Hatchet_Jack | Charts and Charting | 1 | February 9th, 2005 11:31 PM |
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Bearclaw Chris | Charts and Charting | 0 | February 9th, 2005 05:59 PM |
Results of a formula to be Number instead of formula | dlanden | General Discussion | 1 | August 3rd, 2004 05:04 PM |