Charting null values

[StephanieH]

I have a chart that is plotting null values. I tried the formula
=if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a
completely null cell.

I've been to Tools, Options, Chart and selected
Plot empty cells as
Not plotted, zero and Interpollated
As well as turning Plot Visible Cells only (turned it on and off)

Nothing seems to make a difference.

Any suggestions?

 

[HEK]

Stephanie, what kind of chart are you using? Can you give an example of how
your data table looks like?
br,
Henk

 

[StephanieH]

Here's the data table:
2003 2004 2005 2006
1st QTR $480,225.57 $728,453.06 $666,902.66 $637,340.65
2nd QTR $541,123.51 $899,090.95 $711,704.53 $176,706.39
3rd QTR $490,729.23 $314,911.38 $882,595.19
4th QTR $551,334.47 $386,755.70 $691,980.60

It is a Line Graph

 

[HEK]

Stephanie:
I tried to mimick yr chart with Q1-Q4 on the X-axis. If yr chart contains 0
or #N/A in Q3/Q4 the line for 2006 shows zero values for 2006 Q3/Q4 but if
you set Tools/Options/Chart Plot empty cells as "Plot nothing (leave gaps)"
you should only get plots for Q1 and Q2. I am unable to reproduce yr problem
(sorry).
As an alternative, you may try to enter yr series for the running year (in
this case 2006) as a dynamic named range with the OFFSET command.
Instructions for this in many posts on this forum or e.g.
http://www.ozgrid.com/Excel/DynamicRanges.htm (just first hit on Google;
there are many many more). I hope this helps.
GL,
Henk

 

[Andy Pope]

Hi,

Is this a typo? =if(C25="",N/A(),Sum(C22:C25))
as it should be =if(C25="",NA(),Sum(C22:C25))

Cheers
Andy