Graph won't interpolate?

[Guest]

I have the following data points and want to construct a simple line graph
that will draw a line between data points... ignoring the zeros to make a
curve (see trend line and the polynomial trend to get an idea of what I want
for these data points). Excel will graph only points and the line drops down
to zeros where there is no data... which I don't want it to do. Any Ideas??
THANKS!

3 3.53
6 3.8
9
12 3.93
15
18
21
24 4.03
27
30
33
36
39
42
45
48
51
54
57
60 4.11
63
66
69
72
75
78
81
84
87
90
93
96
99
102
105
108
111
114
117
120 4.24
123
126
129
132
135
138
141
144
147
150
153
156
159
162
165
168
171
174
177
180
183
186
189
192
195
198
201
204
207
210
213
216
219
222
225
228
231
234
237
240
243
246
249
252
255
258
261
264
267
270
273
276
279
282
285
288
291
294
297
300
303
306
309
312
315
318
321
324
327
330
333
336
339
342
345
348
351
354
357
360 4.43

 

[Guest]

if the cells are really blank got to <tools><options><chart> and for current
chart select interpolate.
if the cells are the result of equations with a "" then there is more of a
problem
one way around it is to select the column of data and use <data><autofilter>
select non blank.

 

[Jerry W. Lewis]

Likely the cells are not really blank, but "". Replace "" with #N/A to
interpolate.

Jerry

 

[Guest]

Thanks to both of you!

Cheers

if the cells are really blank got to <tools><options><chart> and for current
chart select interpolate.
if the cells are the result of equations with a "" then there is more of a
problem
one way around it is to select the column of data and use <data><autofilter>
select non blank.

 

[Jerry W. Lewis]

You're welcome, glad it helped.

Jerry