| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Graph won't interpolate?
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 |
|
#2
|
|||
|
|||
|
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. "John" wrote: 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 |
|
#3
|
|||
|
|||
|
Likely the cells are not really blank, but "". Replace "" with #N/A to
interpolate. Jerry John wrote: 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 |
|
#4
|
|||
|
|||
|
Thanks to both of you!
Cheers "bj" wrote: 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. "John" wrote: 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 |
|
#5
|
|||
|
|||
|
You're welcome, glad it helped.
Jerry John wrote: Thanks to both of you! Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph with pivot table | Excel Discussion (Misc queries) | |||
| How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Linear Mode
