Shading Area within a Scatter Graph, Working outSize of area

[woca]

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

 

[woca]

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]

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