Charting null values

G

Guest

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?
 
G

Guest

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

Guest

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
 
G

Guest

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top