Shading Area within a Scatter Graph, Working outSize of area

woca

New Member
Joined
Oct 10, 2006
Messages
4
001ju3.jpg


As the picture shows, I would like to shade in the two areas and then have Excel calculate the size of these areas.

Kind Regards
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

woca

New Member
Joined
Oct 10, 2006
Messages
4
Thanks for the reply eliW

An extract of data. Without Coating (W/O C) With Coating (W/O). The weight (kg) is the amount of water remaining over time (seconds)

W/O C0° WC0°
(Secs)(kg) (kg)
0 555 530
5 480 420
10 440 365
15 422 342
20 413 320
25 405 311.7
30 400 302.2
35 393 297.1
40 389 292.5
45 385 289.8
50 381 286
55 378 284.3
60 374 281.1
65 370 280.1
70 369 278
75 365.8 277
80 362.6 274.7
85 360.2 273.1
90 359 272.5
95 356.6 271.2
100 354.2 270.1
105 353.3 269
110 351.3 267.7
115 350.5 266.6
120 348.9 266
125 347.2 264.5
130 346.2 263.5
135 344.5 262.9
140 343.8 262.2
145 342.5 261.8
150 340.5 260.4
155 340.5 259.6
160 339 259.3
165 338.1 258.6
170 337.2 257.4
175 336 257.2
180 334.2 256.4
185 333.7 256.4
190 332.6 256
195 332.1 255
200 331.5 254.1
205 330.8 253.2
210 330.2 252.7
215 328.5 252.6
220 328.2 252.4
225 326.1 251.9
230 326.1 251.3
235 325.6 251
240 324.8 249.9
245 324.1 249.6
250 323.9 249.5
255 322.3 249
260 321.9 248.2
265 321.3 247.7
270 320.4 247.2
275 319.9 246.6
280 319.5 246.4
285 319.4 246.3
290 319.2 245.5
295 318.2 244.3
300 317.2 244.1
360 311.7 239.7
420 306 235.6
480 302.4 231.9
540 299.1 227.9
600 295.8 224.7
750 289.7 216.8
900 285.5 209.5
1050 281.7 206.4
1200 279.4 202.8
1350 276.5 199.7
1500 275 195.2
1650 273.3 190.6
1800 271.4 188.8
 

woca

New Member
Joined
Oct 10, 2006
Messages
4
Basically I want it like in the attached picture; ( I did this in Paint however). I would then like to calculate the area of each coloured shade.



Regards

WOCA
 

Forum statistics

Threads
1,141,721
Messages
5,708,092
Members
421,546
Latest member
delatollas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top