Making a gap in a Chart Plot Line

**steven723** · 06-05-2009, 01:04 PM

I am looking to see if someone knows how to plot a line in a chart where the line will not jump to zero when there is no value in the cell. Please see my example I have enclosed for more information.

Thanks, Steven

**shg** · 06-05-2009, 01:42 PM

Replace the blank values with =NA()

**steven723** · 06-05-2009, 06:37 PM

Sorry... I am not understand how to use the =NA() function to achieve my goal. I have tried it and for some reason it continues to plot the data and not leave a gap. I have included an updated file which shows exactly what I am trying to do.

Can someone please help.

Thanks, Steven

**shg** · 06-05-2009, 06:43 PM

A gap, OK. Then delete the contents of those cells entirely.

If there is another method to return a value to a cell via a formula that leaves a gap (vs what NA() does, which just interpolates across the values), I don't know of it.