Is it possible to ignore missing values in a chart?

L

Leo Besemer

Hi,

I'm trying to graph from a simple table, putting the year in the x-axes, and
plot a line according to the other columns. However I'd like to ignore the
missing values in the table (indicated by "n"). By default, the missing
values are being treated as zero.

1992 217 260 43
1994 214 260 46
1998 215 263 48
2000 213 n n
2002 219 264 45
2003 218 263 45


Is this possible at all?
Thanks for your help.

Leo
 
F

Frank Kabel

Hi
if you replace the missing values with =NA() the chart will ignore
these entries
 

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