Eliminating spikes from line graphs

[David]

Hi,

I want to eliminate spikes from my line graph by not plotting zero
values. I want to show a blank instead of a zero value on the
spreadsheet, and I'd like to join each of the 'peaks' together.

How do you do this??

Cheers!

 

[Phil C]

David

Generally, I would suggest using a scattergraph and selecting the 'scatter
with data points connected by straight lines' option.
More flexible than line charts
Assuming x data in column A (say A1:A10) and y data in column B (B1:B10),
put the formula =IF(B1=0,NA(),B1) in cell C1 and then 'drag down' to C10.
Then produce the scattergraph from columns A and C. Graph will ignore the
y=0 points.

HTH, Phil