Easy chart question

[fidgen]

Hiya, I have graphed columns of data that contain numbers intermingled with the #N/A error.

What I'm looking for is to have a line chart that breaks the line where a NA exists and then jumps to the next number rather than joining the line over the "gap" to the next number.

Cheers
Hugh

 

[fidgen]

also!

is it possible to set the chart to draw a line over 1 NA error but then break if there are 2+ in a row?

 

[Andrew Poulsom]

The only way I know how to do this is to leave the cells blank. Then select the chart and choose Tools, Options and on the Chart tab click Not plotted for empty cells.