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