Plot Line in data table

  • Thread starter Thread starter Daniel Chalmers
  • Start date Start date
D

Daniel Chalmers

I have a table of data

8 9 10 11 12 13 14 15
1.00 28 32 35 40 47 59 71 82
1.50 42 47 53 60 71 88 106 123
2.00 56 63 70 80 94 115 141 184
2.50 70 79 83 100 115 147 176 206
3.00 84 95 105 120 141 176 212 247
3.50 98 111 125 140 165 206 247 288
4.00 112 128 140 160 188 235 282 329
4.50 126 142 158 180 212 265 317 370
5.00 140 158 175 201 236 294 353 411
5.50 154 174 193 221 259 323 388 452
6.00 168 189 211 241 283 353 423 493


I want to be able to plot a line through this for a specific value. Is this
possible. eg if i want a line for 120, excel will find best fit line through
chart. I want this to overlay on actual values as above.

Any help much appreciated.

Thanks
 
Sorry, the top row and left columns arnt included. Correct table below.
28 32 35 40 47 59 71 82
42 47 53 60 71 88 106 123
56 63 70 80 94 115 141 184
70 79 83 100 115 147 176 206
84 95 105 120 141 176 212 247
98 111 125 140 165 206 247 288
112 128 140 160 188 235 282 329
126 142 158 180 212 265 317 370
140 158 175 201 236 294 353 411
154 174 193 221 259 323 388 452
168 189 211 241 283 353 423 493

Thanks
 
Daniel said:
28 32 35 40 47 59 71 82
42 47 53 60 71 88 106 123
56 63 70 80 94 115 141 184
70 79 83 100 115 147 176 206
84 95 105 120 141 176 212 247
98 111 125 140 165 206 247 288
112 128 140 160 188 235 282 329
126 142 158 180 212 265 317 370
140 158 175 201 236 294 353 411
154 174 193 221 259 323 388 452
168 189 211 241 283 353 423 493
Click to expand...

I'd use a surface plot, using the contour sub-type. Select the data table,
use the chart wizard, select a surface chart and the contour sub-type.

To put a line at a specific value (i.e. 120), select the legend and from the
menu click Format | Selected legend | Scale tab. You can put 120 in the
major unit box to get lines at 120, 240, 360, ....

Dave
dvt at psu dot edu
 
Are you plotting a LINE or XY chart?
Which are the x-values in your data?
Bernard
 
Back
Top