How do you plot a discontinuous graph??

[bat18]

Hi,

I have a series of data which looks something like this

Week 1 2 3 4 5 6 .......

A 10 N/A 3 3 4 5
B 5 10 n/a n/a n/a 8
C n/a n/a 3 3 n/a 8

When trying to graph this it produces a zero result when n/a is present. I would like it to be discontinued for that particular week. For example for A i want it to show a point at 10 a gap in week 2 and then a continuous graph for weeks 3 to 6. Any ideas?

Thanks

 

[Damon Ostrander]

Hi bat18,

I suggest you modify your formulas so that the cells contain null values ("") rather than N/A. Then you can simply go to Tools > Options > Chart tab and select the "Plot empty cells as" Not plotted (leave gaps) option.

Damon