How to create this bubble chart?

hrithik

Active Member
Joined
Jul 26, 2010
Messages
336
How to create this bubble chart?

SurveyBubbleArea.png
 
Last edited by a moderator:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
I can imagine that creating the bubble chart area would be easy ... labelling the axes wouldn't be easy, but if you have the chart embedded in a sheet you could have cells near the chart object for the labels, if that's acceptable?
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,968
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
The axes go from 0 to 10 (X) and 0 to 8 (Y), with gridlines every 2 units, and with default features (ticks, labels) hidden. The X values for the bubbles are 1, 3, 5, 7, 9 and the Y values are 1, 3, 5, 7.

For x labels, I added a series with the X values above but with Y=0. I formatted the bubbles to be invisible (no fill, no outline), and added data labels using the Below position (you can add the labels manually or with Rob Bovey's Chart Labeler, free from http://appspro.com). I did the same for Y values, with the Y values from above and X=0, hid the series, and added labels in the left position.

It took me longer to type this than to make the chart.

Keep in mind that people do not accurately judge the values represented by the bubble size. If you removed the numeric labels, there would be some confusion.
 

skinnea

Board Regular
Joined
Mar 15, 2003
Messages
126
Hi

I'm just starting to explore bubble charts, and the one above looks like just the kind of thing I'm trying to do.

I want to show the number of 'things' that will be done by 7 teams across the week Monday to Sunday.

So that's Y axis = team names, X axis = Mon to Sun, size of bubbles = number of 'things' being done.

Jon - I don't really understand your instructions... could you possibly type a little slower so my hard-of-learning brain can follow you a bit more easily...?

Thanks in anticipation...
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884

ADVERTISEMENT

Hi

Maybe you can do it one step at a time.

The first step is to create the basic Bubble chart, that you'll format later.

Since you have 7 days and 7 teams you'll need 7x7 points.

As you know the bubble chart expects X and Y numerical. In this example I did 3 days with 7 teams. I chose for the X values {0.5, 1.5, 2.5} and for the Y values {0.5, 1.5, ..., 7.5}

I used the table in B3:D24 and created the chart.

This gives you the basic bubble chart. You have then to format the axes and the labels to add the text values you want.

If you have not yet tried this first part, try it.


<IMG SRC = "data:image/gif;base64,R0lGODlh4QHNAff/AAAAAAA6OjoAADoAOgAAZjoAZmYAAGYAOmYAZmZmOgA6kDo6kABmtjqQ22aQkGa2/5A6AJA6OpA6ZrZmANuQOv+2ZoCAgJmZ/7b/tpDb/7b////bkP//ttv////b2///2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAADhAc0BQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8eIIEKKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3MmzZ0uBMDkg0JASgM+jSJO+NKq0qdOmTJ9KnarTwkmgPKNS3coVptauYMOW/Cq2bFirJrHuJGu2LVW2bq8OvED3AsG4LuHiFQmgrt+/fvXuBYF2rOCZh+P2BcyYbmK8j8Uubky5bmTJg0dOrszZcWaRhUmq1Xm57ObOpc2m5nq689/VrD+HbO2aMeypoTXfLiq7d1bfRQcC5z18Nu3Xu7vm5pv8avHnMptD/yx9eublxl9OcCAAAAOU1a3v/w0v3i358m2xgxid8zx6074F1gbMPrP792fl9ryfdT5l/vsp5t+Ar0GG34GE6fcbZAT6B+BND+bV4IS2qWadfLZFiJR69UHIIIWuaUiTiCodByKBJJYInYkFPsfhfSlGd2KL1LXF4oyNxbiSjgge9WKA5d31Ho8S4hhYjT2i96NLGxRAFHFJikdklO1RKd6Sa1l5oZYrAncjZ1PGhCVp9hl5JJKDfemgbGFeZWaIcY1ZpY1vomageXX+d2dYauZJI1hy4tSmaH6CqRiehVZonmSJDjhogmnBKGCjlo03XqOPOmcapYaWFaiHbPaZY6YskbqjqJaZuuOllKoKmoIwURfQAHhcdlnrcK4uldCVsJJ5K66/ehkscP+f2pTrsGmxaeSxog0pnJK9zoksmqpx6tmhyuLI7EjF1rStm3Dauqm1Z1qYZqHbdjtikAUNOSmnuX673pvyqovYtGxSR2++KxIUmJAuRisovtQSvKjBe9lLUgXfgTDBA5oijK3ENlIcp8CgXtguevIi2zGyCsf0Lap28msxfL2RrKhsIXv1YaLbfqxZbTJrpm+d37a8FKvo2jcdhvTV3GyZOH+mc14pzyiz0LUKDXSIQh/908kVU42Z1WJJDQIHB2Rg2Edghy322GSXbfbZaKet9kBarzqeyqiNjDWfc+cXKZCMkvvn1XVvxXStbasIFtx+Zvr3bDlKKWXi1gUOJWtpendKt8aLPbullBhaPp3jtFYbuV0T9z3V4VpyHjHP2qYsut+rb6W1UE8m2/ros0tFupWmy167UzXPBbXTuz+V+1jB8/4yzJYmfeLHww+NK80/e/456OYenyezzdv8/Hx/k0p46ii/23PC/xgbWzxUiJLrqrzfrzxY9nydr9TI7f9rMuYdBny3S1xn0GTszpOfT24XJQJGCX4CTKACg5c/mfTvfwvMCQcMQAAARnAmFPjOByAAsQvWhGFbG4phPEjCEnqwgSZMoQrrhsIVuvCFBmshDGdIQy7J0CQQrKEOdxgfSfFQcD88XRBLgsD1DLFzRwxgEl+1vyytqDK36x2KivOx+lGPZeXz1vbWREXlgaiK2VoWFpvoq35tRnPi8iL3uhifLxIri+taohKXaMAkFbGOPcLjgfR4IKlRQCCzEqIc+eguOXILjvd6jr+Qc8PkKcaKo0qTIQ9JRmlZD3w+G9f0TEXI99zxkkLXkySfpkef8G1RcsP5JCjNFDNNktJ7QSolryo5sJQRrpGmdCWm9jRJVU7SiF5CFS5zKcejgRAEFOgg8X4JzEl2Elr/tMxYGB3FxmDSjGnMgqSeyBdN84lvfLykE/IcOUpSXitriIxO+qwVr2+O82CDM6csAZVOka0TXuHMGz5D1xVtuhGd3dQi6vaVyYFikpz61JuqfEk5PD5TcaFSWseOtoEFdEBWX1ubRjfK0Y569KMgDWlEGGrI7i3SMQCrZi/r6TJmZhOc+STaFN8Y0DgqEooQlR47+elOpRmNpTu7KSpVmtB9Vu1cRbsOUJHmUoMSNKZOXaNvSDpIXD0NisPk20prihLYCZKOTWUmVcH6y4fOcoQLimiDsjq4sFIRevpDqxN7ysqCPnFvirzZU7kp1zKKc5cIVSNO84rUUL5vqVMrU2xdC0ZWvS6vN2MNle9QikZglZWZkOrrSjYokIbpzplu3apma2lLYbK1rZcVK2JLRVfD8jSJZm3cat0WT3mec3KgVS1X1Vlb2962nz8bbBrfuk3o/kR2dLblZGgNeVzI7RSqQ4zt5mYLxGCyqLLxWW4xV+vVr8JWu0tsbhBj5trA9vCqdsEuZKn7uJ+pl7C6fG71ovrPw+7Wnl6aqWXLaU5YrnKv6WEvEk/JuOH2s79Hbe1B3SLeH8bLqPBUK4pk1mAemnSy6X0vY8O71Ip24AMR8NpnSwre794XsyhOsaDI42EQi1iO3V3iBgbw4l9iVDTSVbGOsXbaHfv4x7oRqZCHTOQiG/nISC4bkJfM5J/kuMlQbtqTo0zlAq7Gw1XOsoNTc8wBkzi1v6zwDqcsLN2OVppfzm2YBezdI5I5u+5tjYZ/euKg4s+hVOxTj4Gb37Wm/5LNIxZscYmqWP3er9AUmiigl9lGahL6v1I9NKQNzVcc463RcH30pIdqV/pSutK6uXSfhQvfaXIRzqb283rrzFQwE9h9+8V0pKe66Dk2Ns0N3bNZxKzDN6vOzJZOq5pxzdwOW3SDyrS1iYddbFY/LCQ3ZjSzb93sM3vT1efFavcwy+sa0m9Z7ON2rbUn60yX+Z6FM28Su/0WAKvbb5uMcLWDPVcF1/fdtkvufOM851VbW6D2fqwoeytPwwWX07RmdWLRXV55w9u3BhdqyYrDbt4BFt8WhzgxRw3rPyuctZ6+N3SR+8oEzzvUwg75rDvNX/nue7sfp20Pr2ng+Lr75Tccjnl1ia3yiW943YidgEAq2Obo5npj0QM2yl3igQ4gM9nrSbLUp071qlv96gCoOAx9LenSatu4/+OOnyJPmmFdo/bOhZTpgvGi9XyvHeM6/fTA/9oqtod9NogWI8vprve5F9XlAP23TeP+Tof/veE4fziCPXX3Ztq88Ik/MOA3TnLfXlE5jedkvA0vefW9tvIat5vgE0n4i5v88On+vNst/6i2H8WfCNdq6ZOq+tUXnPE6b+/s+z5ygt888u0u+a4z71ifdt08VjQ7+gLO++Hn3svUQe+osGnGpyFd06aBPUqV+vyij7fEbzNtzaQG4gQEMtDUTn/OR3+SaEub58sWLb39Cn83i7v76I9/8Vf+8yO6foXkRXtwt2m/lXDsh1/Y9ni/h1v7J3d2h3/vR1zlcjm7l3qnx1lwAmdfB9hSr1Zg2Kd4k8eABOhoGjh/llRugxZrLed5F1iBIsdgxNcvkUSBCmiBwId6LwiDEKhs9oeBiCd7PRcudLaBdjZtLphoe2cfpkVxMZiAkNE+yrd8a/+2g+RmhHkWhSIIc0QYEkIHAFBXhfVndErHHDPxbEGGdWiYhmq4hmx4Ef+nQlzXf0P0hikUh0nof004c1BTcz3ILlhIT1QodmqXg71nYR0ohP5mgqTFfKrmd+rHiD5XgktHf0dIiJSXahP4gTiIhNy3hQvHdzbIeYOYgqg2gg6Ie54IcpDYiIW4aYczMj8YYIGId0F4ipd4Xv12fKBoic6XijJniojoiPo3iqc2Rr64cw0Ye3f4fdV3Rinlcceoe48ohlMYjdA3jcxYjYrYEu4HhlXlhEDHajl0jbhoEEECfnOYh28jUaX4jdo4iSdYg83XgtQof/C4iCsYgmcXhuk5OIuO13nCd4sOdn/W6H1QwXo32EP44VB4RIfeYnkFyDoHN098iIIRSVMFmX9PoX2cmIUcl4mamIy3/+OQDxl6QDiM67eN1+Z7n6Nc4IiH/qgqHElqCTlmBKmSAOeDb1eTvXaT94hmecd/yziQY5gdLzFBRGeQhviS/ZiKMRaB2EiU70iGKeeODZV29kiV9caPlaiMotiUODl4XOlcMPWVwHiRkqiVlBiVoAdhArmJtoiKYUl6EthxKsiS+iiRtUiCD5iRUEmMpPhrcAl5+6iTxteXc8lbFumVAzg/+vaWIFiWvZiYCLiYHnhu+ciCkBmZAqiDfsmDkvUvBKR5LWmWeLmTcvmTKzmWbUmYJ7mKNAlqahmPbEmWnWmaj0RzTBiTmFVFt7Q0Pjmb+GiVxKmFlCkSx2SGf9mHrCm5Q1JTAQLxhYJohfVYf3+oZdgJgHaYndwZKjqRnNIZRE+5RON5RH8knf/XCZ1e+Evl+UNdCEiG1IXnp5rdWZ/jtZ32mZ+qgZ/62Z/9xJ/+GaC2A6ACWqBJcZ0GmqAng6AK2qAxRKAOGqEjAqESWqG6YqEYujvD9EcDMZ8Z+qFUclrKCaIkmiRsNQEeahwCYQEs2qIu+qIwGqMyOqM0WqM2eqM4mqM6uqM82qM++qNAGqRCOqREWqRGeqQvilhYRo7MWZwpSZ9i6aRNapxQSpfN6W3BaZRbKaXVSaXCCZS12ZNFGXWixqXZmJVaupYoOaVj94xgx5voiItYaU1g8jckSULdE4mYKWh6OoTHWYRXKJrn+JHBqIuwiVdpmaa0iYmI2o6A2afCeJYDdomY/1WqmJY5qXK4i0LZmKcZl6n5pavJqJfpqHtJkZk6mJvqmX/aanzKmK2YmXw5lKiaqpNZqZUpqoF5qrMam5xqm4eZqGRalck4qoI5rIUaqYZJq7UKqjl5qSBJqpL6rL3qqx3Ziav6iYeIlsWKq8Qqq/J4rJTKrFHapnhmVbp5l4/qqrL4md4Ypo9kfbk4rbt6eQZ4rapInWcaqIwkW3DKlFKJpsG6pe5KQxS6rIo6nAM7QwX7qQcLpmvapU8qrlZqpv96chJbEhzqWcsJsWwajlvYjRrJsSILlrYqEhOgAE43olHXhizbsi77sldnTA2jstN5pQSbpQGrph1bWgeRUzoAy6AL+5rryD3AM6ZA25utWoze6pzqSK4M+hbpOiFyY7Q+RKdxU5Gdipoe6bH2+otp8pvomrULyGdT/9mwoXqo3Vp7waeZPKlDd7ofY9u2jlma9EiyF3urmvqrrzq3m7eZbtu038qLW9uakeNfF2KqcdW1yBi41aq2B2mShZmt9AqNiiuNsLpY8tofkEu2kiutflqygMq4gsu51Nq3kZu0jfq5d8uBeYu5jsu3tye0UVspiQu6rNq6eoubB4qQsju7h/O27WF6rwu7pnu6ehg0/MquNYu7jTu8uxu7vcuzTysVwEsasVi3tle42PtD1Wu9rousa6tQuvu3/Tq7kLq3GeeWfltD3TtAnuq8G6m+60tD7YsUBSGa0zs/Q3s92YSzRxunfKJN+YuwXGu72Eqx+ym1wEm1ZZqwkkshfamybQzsEi62uA+br15qtidRAQHQHRoLmhh8wUEUOCBLi/66lGWbsywhn0w6shV7hT2bvJXbwiG8s08ofpRrwPfKbwsJwA/Mjsb/OMNKuZ96NsANLFnwGq/wOzocacQ0Ub/tAYULbEsTFraX+70Gq8IE3JXmBr7ZB8S6SrihyLBa7LDzqrRLnL1aG71qLL+YV77MO7qkG8esmMavt3hk/L90nLvzm75jLLf2+5iBJ8Qhy5mS2cfE+8dsnMjFyxVQ7BXaa8eBnJdzbMh0K3qEvLHh68bGC5DCi8hrAZGTSxWPXCSRvL1t7JqdHL8Q2XqAW7p1N76Py7ag7L28C4jKa8Kiu8Z6ycUZiMrPe8tvnMv/eMXXW8lii8WLPMnC7MivDMuHPLjQfJvLzMzQi8uZDMKbrMrSPM3zWMuhfM3YrMNee8Z1DMxi/M3ghGzLAYnJ5GzB5tzFkjzLyozO9EzL7ry6obvHylrN2yzHq2zJ0TzM2dyuySrPmfvP/QzI98zNBP3Olhuto7y0CbyHIenNv6yqEE3D4ZfETjxAHKPEFI3RaHwxcIzANums6prHVYuvL+x1//HRO6E1GyAAKbq8DvxCQZvPGtx+DVDCumyzCv/rv6XBofBZyC9twyM8W0BdzDntQjs9zvp8uygtpimsxy7Ns3OawWV8tiKMfEVctFfd0kLtN1IMrTBJzFGNzL58vgydfRh2fTk81Qf81IzMy2y9vxaNkQWN018t0Hjdy8bq1hpN1ztc1azMyXnd1rla2D09sTAs0/aLtufszwottUG80UOcmxnis/HcvN1szJW9rn0d1CpNOjJ5ym+d2PWcxVit0to60sEsvvaczhnt2F3drKjruWHc0IoNtUHJx65N1rtNu6X22Zgty5cN2qSt2UjtaVF00K0dG+Ybqyat1ouTunsq2nEL3MHN3MN9xEq93N3t3dVN2Cwt3i4M2Oo/HNq7nLa4/dqIbdsALdiD3djh+tiWWtas3d7rzN7GPdf6jbd27cf1vdhyCk3Y7cPvHeCGutQnXeCsQXZyvd0R/zvgrMvfUE3U6l3D681DMhtCFuTX453SYx0T58nRKKzhLkTCN+3Uf23VP5saLLzZWHrCIP7MHy7jFovh+xzjN37iwgrkNzvBAovEQSPZR77j5LvgsK3dCQ2A/OaMIt3chl3OlM3byr11eeYgUaPjyI2ptc3lTw7f8U3c/IzQW67Txa3mZ97hnjzdlg3WVY6+AF7Sbz7k3A3ec/7DnZ10353cwCrfDY7n/03eE/3ge27o6a3ncX7MAT2CElyqC+3MEb7ofB7pjDjpEo3eD33l8Pzo5U3dnevgaF3oK23pTi7dgm7nFYja9/2+n+7jVI3qbt7n8TWasW7deb7kmM7ouCAOh20Orr2us7Yu5qst5cPOq/md2+PK6qmu6Ty+64hrrf/OrckVXcUWXuKb/qarTsV7bcUeblVK7hOlfKB1HuXCbuTGPu5JndalDePcHuQzDucrPt/0u1QZBALIZuNFntU5HnPtKe9M/u/1/hIzVmPYfu8SnkJH854A8OLYBMGUBegsvkLnbiwH7t7TfuHODtlpHu2kfvEqlPFL8cljzubsvqiiDukjj+8zZPI7otrJvu5C7uv0rcgIbuIHj/MGfsnBXocc7uj9DfQcT+89/vH7feexHPQmtNaqHu+DMpOjTTuUU/Ge3aZYL8PXrs2zLcjSvkrRfbjIrrq0Xtep3Mj2famwPpFlP+honvZG//KHOPZur+Vmr/QELvc0T/eEGtsQvS32ZyX1Ye7ftuMsPYz4nv8E5r49934/7+zL+I2Pzzvf8QUM6hGd8wO99pCf75fO9KO+kQze5IQP7RtvPDjOtJ/f8nJe+UjP1YT+xTgztQCv+t/+hGAc+EO98lv8rl4u1iTv8NwlQv5uI7uS9UTu+Vv4ARKAAcT/3DwP8zD0Os/PHDB7/dif/dqfNtQ/4iRe8Lt/8+3+7u7OvZIf/eWIv6849D7P8Hrt5dsO711v0J3PxOCm6Ehc7jwh87PzUgBxQeBAggUNHhwIAMRChg0dPoQYUeJEEAopXsSYESMAAAgNctQYUmRICxFBjqRoEeVKli1dvtSoEibMjh5t3iwoc+ZLnTt9VqyJ82PPnzNLQjyZ6ZNoUaZNnW58OjKoUKoIl0adeBVrxqlVD2rdevHow6Q7wYZFm1aq2qxe3X5lmzVuzLc2z85dONZh2Zl38UrkODXwX5d+sXat+9bwYcKAE+NcnFZvQ740G4tE/PHy2saZH3uN7DT0Vs+fCY7GOplhZZ6bN4J2zfVyadOQN6OOSrs27qeqF7IuHDslbOEpZ9d+zNtscd27i4Pw/w20qHK0zTU/N9kZefLZzLfbLR4deEvqYa3nxJ6d8Pnv6Dt7bw9XuPjye9OTJX7fvvb4VOu3hq8/gf7zib7p9NvLPwTJOk5A27oLUEACdzLwpwlJA29BBht00KMLV/qQJgdDfKlCpTQ0aTAU1eOvQ/kgfI69qkgsMcUDV8QxJBoxc/G62+6T8UHsTFwuRyMv2lGqHi9IkjMgndOPyL6OpBKwCPtr0kkEg2QSRSktqzJMyrDjUkjmcgyMo9PSzPFLAMUUM0uWynQPSDjhdDO4O8OUszA1hVJxwT73ZCpP8gitclALAz1SUUQptDGkCjh6wMpHjXT0Uj01XdFQiDZYoMeDDyLIgEVONcz0VJRSVXUkTx+qgIGFJqiUsjRvxTVXXXfltVdffwU2WGGHJbZYY49FNllll2W2WWef/fVVhzg4IIMNCtDA1Fbt3FY/VruVDalvwSW3XHMfHe9cdddlt929xnU3XnnnVStdeu/FN18U7RVpUgBq1TcsDhDINuCoPoCAI1kNxmoCSsXdCVRRSWX4qQ8kwIDgireioIGNoxq4YFt3inVWgD8uKmSUm6K21JWdopWs/1q+VuSXd1L55plq1vmnkkGIR/ndnocmumjA4DU6aaUxRXppp59Oj1+op6a6W6mrxjprQq/Wumuv0Wz6a7HHBjFsss9GOyuz02a7ba7bhjvupt6Wu267yQsIADs=" ALT="MyPic">


I used this values in the example:


<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >E</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">X</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Y</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Size</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>8</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>9</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>10</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>11</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">16</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>12</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>13</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>14</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>15</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>16</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">17</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>17</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>18</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>19</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>20</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">8</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>21</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">8</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>22</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>23</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>24</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>25</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=6 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>
 

skinnea

Board Regular
Joined
Mar 15, 2003
Messages
126
Ah - ok, I have this now (or a 7x7 version of it).

I hadn't realised that I needed 7 reference points for each each day...

I've scaled the bubbles to 50 so that fil in my grid, but so far it looks just like this... eagerly awaiting the next step :D
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884

ADVERTISEMENT

OK!

Now you just have to follow Jon's instructions:

- right-click on the X axis and cleared the Major and Minor tick marks and also the tick labels. This means that only the line in the X axis remains

- add another series (like in G4:I6). Format the bubbles as invisible

- use the chart labeler to add the labels to both series. If you don't want (or can't) to install the chart labeler either you have to manually edit the labels or write some code to do it.

This is what I got:

<IMG SRC = "data:image/gif;base64,R0lGODlhugJsAff/AAAAAAAAOgA6AAA6OjoAADoAOjo6ADo6OgAAZgA6ZjoAZgBmAABmZjpmZmYAAGYAOmYAZmZmZgA6kDo6kABmkABmtmY6kACQOgC2ZgCQkAC2kAC2tjqQkACQ2wC2/zqQ2wDbkAD/tgDb/wD/2wD//2aQkGa2/5A6AJA6OpA6ZrZmAJCQOraQOtuQOv+2ZoCAgJC2kLbbkLb/tpDb/7b/27b//9u2ttv/tv/bkP//ttv/29v/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAAC6AmwBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEkyZI+TKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qNGjSJMOFai0qdOnUKNKnUq1qtWrWLNqTcr0ZgsJO7aKHUu2rNmzaNOqXWu1K1EAbOPK5Ql3rt27M+vi3csX5QuZbpf2LWpwMGHDPwGQWMy4cWO9iHdCjnxTsePLjynv/BszsNDJmmtaxiCB8QKBAUQsBh2aJuvWLy03BoGAxIgBImhffg27Je/eKWXPrs1Y927gMjnD9Bz0N/LnXKG7Fr7buXSU1qVTx7z6ekzlsbPn4hTvvbxk8+iNkk/PPjng9S7A9uBxwkTs9vh7rs/PX+X+/v2B5xJzQP0Hm0DcPWbggeltl+CDjC04mIQAsiegbxQu12CCIBjkQYIZ8hWiXA5e1iFxi4UAAIoPjhiXi5EB0GFBAcAY2YUsEZjYhtwZB2F3DXpXomPGndYBCT62KGSFwiVpo2E4rqSjT0/iNSRmVVqJ3pU/cpelWl9W2FuU/u2nwgd5ianmfWv2QFCbbsIp50lkBhdmmHYVpOBATML5Zpt4gtkliPjVid2dWw46aKBnMdqoohA6apakWXEJKaHXGXr/0pT6CdnljARV0CWlWpFa6qcsjmqeqVRZ6piKAol6KatUaeomouW5OuuWPF6K6arX6eprZpm+p15/utI6KZME7ckpsFsKC6KyWdn6rEo5WLADDgrUkGNJ4IYr7rjklmvuueimq+667JZrLa5zApqftMS2R21af6757rFibndvo6sOq2qu7NGLZXv7HobsYkliUNu/ZEEslaU+XpCql9AmipmPGKSGsYXGKhzvmhK3KvBxQc6bbMlYJTwTDgXM0IMLCHg74Mjy4kyyzmq6PFMLAtWsIc99El200fz5/Nm8vrLcFtIAOl0VgqNKXZXSzWnMnYofMuzxwSkvTCSKVl9VXLZTDnLd2AKyopwe1gX2ejKQvKrp785yQ7jBx2+H/Baz/l5LMNT8nY1Vvj37bdNXYd1MOH6GP/5U5JIrBfeOAc/tGOVHcV45Up5/XtTlVGqnuaKhY96v20dHzTqA/6R3+py0Saq9qHauj/26vWIjeXGEsCu+dLCnK7mk6HUj713sLnFrs+MFGyw4cqkrn7X1xXZmoPNDYw9d9VEh3q/30jF/Hvmza1083cdDDin4R5mvE/ydNzaCAAy0TQL9nXuK6nC3C1beGoMBAHStY6rhm3nkNx4mheBrjHEY//pHvP8V53dgw536LgOrFUUKZNrjF/qAM0H9rI997YOcpaYHHQaehHs5eIDMoDdCBtWQhDcck/CQx60VoOkkKihBt3IYGe4RsS8whIAMIOCtGM7QJU6cEwuPSMUqWnGEU7yiFrfIRaJlsYtgDKMYVTbGMprxjIUrIRrXyMY2htAmZxYCjBvRokYw1pGLLqzMHAG2x2WRjE9t/8qjTe5YIIYZMEUAONL+WlcwInmQYakipOwaqbsL7m6BO4xb7u43EFlJUpPuAyBjLLa5woXyMqcRiCJLWahMqq6PYvnkFWVZxTxGUY6wHAstq7jLIwpSNLnUZeGaZspgbuWXrrHX3HoJTP+dkJUCNKZWkJmmzPWoIPrL4OC+Nyja3EY1GKhAkoz3vdxZsl5Jc2XpBkjMgjnzmdAspzSrpc5JzvNpyjwZM5N5z6tQ85a+6afZBDrQP34xe8uB16oMpiDenXJXkLPmCff5EmrisoIPAtVAMIhODebqR+P8YMaoBylOxup9CA2PCE0HoZD+iKIBlWiPOKrNaM5OUfcrzUhiLqDTgbWwnnSh5DIdKtRhwbQzH4UnCn/6RjgKjU0EncpRsRi1ZkVIfK1sak2MSMOoQmWq4wEk3rwaFYsilazhY6c+w1bUAGb/NaErDWXtPAbWamI0o7WxnU89mtSNscilS03pgBRaVawiS6YTHSliUYowoJ4PrZNL4/vqClXINoWaNHveodrF2c569rOgDa1oR0va0o7ErN0DnFjHZ9nItvayjp1fW41K1H4VJGdqdWvftDq8vmLGYYxV7EMh2dGIbjCCPV0McBVYHtRW9ri6ZetrQcc0iL5VpVslgEDs89zpisy7FASvUfIIsyemNnqLomx3xdtb9g7FuV0lqVKBl0L3tte+QIFvTG/aTRY9MIEvtWl1RVlcdw6TuIy5X9fUW9HYNpCb872kDavqJQafV4UVFpN+c7RYzVnYwsgD8eeQydX94heUJSdGcYp7smEprVjFCxXYQSkj4sq12D8GXS0j5RvhwPZGxAyNJyb/eXu9AZOANIjs2iIPy1ILIniv1IOucpNLAr1K+Dk3Ds6LXwnhCKu3xkH2sWAxFNctP9he0qvxpszMYgefJIolZrOc55wrNRvFeTiYwA2Y6Lz4hIU+JuBenM1sREF3CwfaRY15X5znPTdRiUzsAaIHEoAZMK4HAAWUnenM6U7D1dOgDnUaRU3qUtfZ1KhO9YE2repWu3fGro61rKe2oMzO+ta47tx/Br0pgrzg18AOtrCHTexiG/vYyE62spfN7GY7+9nQjra0p03talv72tjOtra3ze1ue/vb4Ia2m98sw4vOmtVQQ7fRsoydXKvbaO/mGbvXjOt4U62hrJXstCo0Du84URhL72a1tARu5Oju//bTfzswYMUsXMR6MwFPpm9tF5skl6q53wJfzP1WWeWvodvO2/HRAjIQyWKy87/IremQES6Y1QmZyQUX6bxiHuD8YNzdftLxjlUoHJ3bfNyDxLnQby1I+gjkh/F1dbx5tnSc5TE+LNjuhZWea38THehxtHXSW61uPV3V5wa+OpFhnEbDmlzKwU3erG8+XChLt8vwZHDTR8Z2tKNu4jzuMWWXXhh9Ab2ZvjURTV8u4Lzj9QKrHPngJZ6+3kX83XV/p+DTXl8S9hdJEghBbRZO+AkXfJzqjrzk1/p2y/eY4aGx95UbO3Yud7jmeOevUuWea9HzvDoBzy1t1S5rQU4aAAny2bqqBb4ymK//fdwxNAAAKj11rld97vF6utDy3DgTyxr68dr0vSPFatvHGHXaN6fMZ/763a8cuwkvP+UrP/p2lv7Hp1ev900/+4bLPrH2T/3pCwyb+cO/pYu3ep53VzO1fvJ0fxCCchE3fsjhf63hKpz3K3zVZHhlXYV3IHMDAhAEew34d/xEgPjHfghYPB9GgfE3Zt9SZnB3OiAGZOsDZO0XguXjgXale+QUdmg2WWdngiSIHg6IZrDWePWGYbNiZ0WXAjEwROvlfEN3fK3HEjngAAXBXdYXa9gnRbVHg+Z2feJ3g8Yldix3X1aYT0OFg20ngM2lhWd1ax9Wf/nHgwZ3foOlgo3kFyMqciS5F3h+VRwbyFwH2GFJsgBUxnhy/0hm3yVXLKJgS2Z8K9gjASAAFCAAHMeAQqiHxVEQk9h5TBWGRYYsGnVI9qZ+vjMbAJBNaJh6sxVxKmKKi+iDath8w2eDFiiCIBiHafiE9sSF6KVPYKZazqJhr7iEsVhY23dbUZOFuPgSlyZ8qXaFcuKMgUSDmeZiQ9iEvReMzIhq0IhbTsiJZBctL/Vxz+eLXwd52FiFMWiLFziGZDiLrpiMj2WJpHhSErhN4mccoZhboDKI/DeD8Chb5Ydkd8d7beckO9eIO5VNCydiP/h/3HEBHpNT9UiLG6I2PEWI5CdlCHRkywdgmriJ6NdydqeOf3huZ+h2hZiChyiL/WiPJhfpeH7Iet7oelRnjbH2dPIBaMLYjOOIa/+/1ALMB4s8N3fbOFbdGJJimI4oSZE86ZPnyGHyWIYuqYtgiJSdaHjztXc9WZVzuJIY2E004pGU+GMu93j5NkyfSFfA+I9nRn+fYhCZ6IVkCZOj+JFT2SsNQzbBw5Y4AVbCkiQXSZKa0XWVhJGxxyOAFXpPSY0IGXdMGT1ml5GqFYTA0ZCD6WVv2JRcaYjpV2csCIM26WqCBDQNoITZKCRWtRqRSZDsuJkqaRO8pmXVOJtH2ZWdSZVEGI6MeJOLiWO0GZXuuI6QiXtrOZPrxIaiKGOZOYKCCZK2KZL6Vh1nyZyOKZzU6X4pKSWE1VYXICoLwHHiCIcFeE5L+YBoN04GGiiWLVmZ/70pmwNWcR53jOK5h+TJgVH2eoo4SvyIeuzJl3pUloYpmdcpg5UInM3Zn8aZi61Ziz14lwaqcu+YoEH1m6j5mWaILMaYOP7ZAypQARzqoTupjZPpLF2HjBKqEjBUbmViWizaoi76ojAaozI6o6ElSFG4IpqlJoj2VJjmADxqar9HaYsWah2KEi4AAEhXpC8xjXZTlFulADSAAjLjAhXgPFFoH5mFaGiidXNWaEPkPDq5jGYWRy2AJmXaAy3goWEKFleKpkGZc+TDPSqApJLWLW2apV9qmnJmRG3aAjWjk7F5YipwAEjXAhHwQ4Bqpw5gH0A5pLZVdZAaqa3ipJJaqSdcRJmWmqma+pqb2qmeWhmU+qmiaj2YOqqmyoaheqqqmm6puqquqjOlpfqqshpqsTqrtkpntXqrurplubqrvopfvfqrwgpeU3SkBIF0w5qs3nVQbaqszjpdX6STzzqtlvVFabqFC/qSrqmdNiGtQimiodlqlklqrbqDvLmhgKetyOmU6PqB6vqu53qiALmuTbqahzmcX6eh8tqWuKkyLVKiB2afMmmV39iO/MmaI2mX1smgchmhBEuTlNRBiXSwj7mCHbJKoGeuelhxF2OE/+3Zbge2cQQWngbrO4i3gOGXihwLocvzsfRWXQIZk+83eroRTnW5niVpiSt7igj6sMeJiK8Sn7vpcMQBAuLUsQKqs3/1OxfnslZXXRercQKglvI5XD5yIgqbs5YoiIiUiR7brjXorwA3nak4kTPLsGabnWVCh0MZrIjxcQc6gSwZoGprJ2yrmYW1J3bzbxm2l/val+HKhPU6d+MqauWatKLptId7r8O4rWvrlYJLr7XJmTOhAmBRXiFqaovLuKhGXnqauaW2uReauP55pFv6pptFo6q7uqzbuq77urDrWZ7rLd4KlZJrW277tibqsy1hdABAhegYuTlYNUMrroobuAfaEWS5+yK7//ucSYmvenuQjYmdDqpqheuWAnu2Dkmgcku6f/ufZZu91bu9z0R77Pq9QTe3Dbuw+rd/Wnm+vDuhyVmeBYqVbti9bbd010tjHBKAFGueaMuHAqBkGDAAAfi+jmeQ/Ha85ReBWQvA0zs2IKBTmufA/zshXZixfhu/8Yi2Fky39xnBAHSyC+ABH1xXcEtgF4xlDAycH9yK43uZ//NAGlAaJ8y+kqfAG+y8V8mwLwya8ylKG2nBCNw7PhJv+8u/Hsa5MnyCOBwt9gpC6Juu8yuzT6zEmFmxpJbE7WuAy9nF1anFosbFD7hCJPugXly/3svB8zqZTQdkYXZVo2u8YIutNRQ5vDr4hZPLqTJBpWGbrW1LotKbav95xANS+sd3fLvxysYogbk5EGkrGruSPMmUXMmWfMmu+08qGryNq8iQWYxR3LIbCjQ4+q2f7Cdb2SBp9nN1vIYnybNa+8k9F8pXnHpxrJpSzMiAW7Jxi0Nim14aa79LXLeHcrfCnMaxHMBjKcZvm8WiPMXuqszI7MsJ28uoKM2kh4LcCrnY26AxTL7D/MXN7L7PrMvgG8RSWctYzL3J3MTk7I/QjMjdPHnBGcJKuYDLbM/znCBsI7WsaMWhQcZW4mTTfM33jM/5PJfHjBn388/0SxkCfRcQ6L8PHCPJ+cIrbBhTFWSw4tAsG9AtjM43O5DMHCMgRdEwjL9gDCHLJbVCSpbQmhHREg1SB/HSH63QB/2JcYmzELzQmJFKwFfQNxLSIpzN6mzSYVzSe3HLJM3CrWzKD1i+2rvP1KvUS71/Kd2z9DxcsD7d1N9M1V791UjtzPBszukLjrzIxAO6vlbdF0wNyxBN1GgNzIg7t2eMzdYc108Nusk7EIJctYOLyuH70E4NzYH6svAKyHPNfQHydy4wAJ/LmImdyKoFJ6P5AYf9tP262Wu81S6hAvaR2aKLsMK7yJ4NE6KNvHh7jXt9mqE7ouUIsI5rt9y82qqcx3rM2vFsx6VdoWk9x6oMysuLFzLNZi7ozeJMPcWXTq3NybYt0kLd09V802V92gpadmBX12Cdzipd1Gxd3ZT7vAWj01md20VdcYf03QMYg5/IUTVW3Eidl+UN3OBMzwoI09LN3ksL0IXpbdZUnE9JooiyDd3eJAAeDdcarY8s0s/8rdXh3cOUNFeqMeDe3SEfkp55jcHnWbTp3eA61Ny2i5YocofzPdUrTZ+2YeDiS82AuOD7+d5yHXN8V8X1zOJojN8OzscQ3ttrbX5tPdY1rs2Pe5uK7d1h3d3QXdE5vs1ETtk3rt76zMtK3t/WLb+TfdAeHuUYOtx9Ad+82oVpS9qEDHTGirohztlbTpTN++AzwaTueeWdrNv+jWhmLtlozuPWK42bfOZFjudjXrrTNwHVx+dO3ud/vtuufOdxbtpsDrGLbuidG+PQm6+D/NzYbdn/kv7kJf7juArmCN6BIG7nNM7TWl7omp7RreHlMx3OYm7peD3lqZ7pXZ3hFm03n97Os47jH47oUB3VCbJcDR3mamywR0y2DLqRJEBKWd5/sl7fEYTSLcgk9IzqOB2DMatc7p3LVd7BQXztK17qA6TDwUyd3VmYt44Yqk4iD6JXVkbq+Q3gRauXlT7PaqN5JMDg547uze7sEdRJUF7tw1RAj7TprU7Vn9jh7h7roe6b0/3vAJ/mXL7UUk7res3rfP2VyqnWrz3xur7kQw6d6gvCRw1q2rfcrGzxrv09ZgzYcL5Qwm2OC//mxBjxWqLappbuKTbaBV9qtrSoM1PnMg/pDeA628WME83q3EPvyXT/DM1+mqO9hslQH/VSP/VUX/UcMZo/mvIq79exPe+au+Y6/hJzShDAK+qeWYTa/ehL79/RHCxMTfN+RKGd3eg/m+TRPZipLOfb3sZGXtXD7ueRHvMga/c+jutJr/d0f90Yr3ecTkIZauwqQ8vE3GvGDORObPhnL51e7/Z9u8OJb+XbrcIt/e14n8Elx/LwTkBU29iCj9j8juJHduCwXvMBW5/U/u5aE+ADfPsg3fqavfgnPRt96PAaXvv4fNdClZYAhm44/yiXxxj33fHFH3Mhhfx4me2sj/JIb/kZVRDQPvJ5J+7jnigWV5xsL88nTtbgXrIzDqC8v+vnz9u+fvmYFb/xRE/5tZ3+7Gzjih74ANFD4ECCPf8AACiYUOFChQgZPoQYUeJEigkBkMCYUeNGjh0xOqwYUuRIkiBJnkSZUuVKli1XmnQZU+ZMmjVdvpB4sCZMmz1FXvQYVChPn0UnEjWaVOlSpgyRNoUaVWpMnBF10nw6NSlQoUO1as36VexYsgTDlkWblmlViFcr5nCAoEZbtUwPds3otu7WvX398v0bWPDNnGcL2tiBQ8Hch4YHuzyo93FRx5MtXzaIWfPmgmwbVyaomHHByKVNn0adWvVq1q1dv4YdW/Zs2rVt38adW/du3r19/wYeXPhw4rs9OwU9UDRdzs0xJ3ceXSx06dWhHl8oeeLyxta976X+XaBpjabFlzz7n14s9obhc6qHL9V9da5488a3il+/UvYW5zPfL0Cb/uOsPvs6InCzBL07TcCJ+iNtwYYcpFAmCScz8MCgLnyMQ83u6kq7CiE0y8OBTKwwQBT7ylDDEAVccbAWX0xRIBJPXDHGGuHTMa0ZXfRqvx5ZBHKjIfu6cbwcd7SIoyMxFLLIIp+crsIfNaQyrSQNWpLJ8TTCIAAR7vNyvCjtAwEBjdI8MEuwKLwShMjUDNLBLUVkyc26DEyTzfLK1DOqKzfyE6NC8QoUqkSn+nEEATzQ6AIJNhyxsJ28rC8EMUnAYFIymVzULg3lNI1O+0JdClVFg+p0oxAAgNQjVa//sxQrTDNy1LQKPt1xVqMGXdNUEg6lMT5fUw2KWE3HlJXCO7sEFaMFdtVogQ5IOParbH0C1lBhiaVUv223YhVWjMJkFsFKrYIW1BnxtPJMKbEUEs55nVy3rXYBNa9Ms+S9F9F67Q0Y2xSfvdRfhQEUt+BwB7Zy3nHXqnWmiRdW6+KeugVS4wGjpZdJhG3FuGTSCHb4Izj9jcxJeJ2t2EKTZzYzRY6btZnmmUemiIcTAJCLYZ0V9lgpEBEtGrChF+ZZohwemKEH7rJbGuOkBY3M5KurXqrpiJZ7OmqnuCaa7LLN9tJriMCGGm2334Y77vReVkiFCnqwW2699+a7bxa3rJ4MhwIMMGEgFwZYzG/1plbcuhYk2EEgFSK4uwefP4AobJrpfluxGCaIPAcIYkgcBwIACCBqxVY4CPPGL+NuObAdAHq01/+Cq3AcJtABhahdgLwHuGoXyIWDGGh7Zs7dFq0FzFUwQTS2ZxBc9cRvfyz20hebHvvAXLgb+h6A30H86ckXPnmtAc9+sadhAF36xMOW/XrvA9N+Lvltv98vHlCAX+T+F0Cp2W98wdN2nPLYN5jluCB1BdTf6R5YP/71ry5Ta8FBOACBuQzvgRbsiwPFNj4AFE4gHhSb6QDAAfWVbHkghGEMZXi/F87QhjfEIdpqmEMe9tCHmFrgD4U4RCJiJYhFRGISlUiR4jTRiU+EYhSlOEUqVtGKV8RiFrW4xcgEBAA7" ALT="MyPic">

I used this data:


<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >F</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >G</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >H</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >I</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >J</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Labels</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">X</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Y</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Size</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Labels</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">X</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Y</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">Size</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">A</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Mon</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">B</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Tue</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">C</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Wed</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">D</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>8</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">E</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>9</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">F</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>10</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">G</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>11</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">H</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">16</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>12</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">I</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>13</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">J</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>14</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">K</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>15</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">L</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>16</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">M</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">17</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>17</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">N</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>18</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">O</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>19</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">P</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">1.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>20</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Q</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">8</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>21</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">R</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">3.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">8</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>22</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">S</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>23</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">T</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>24</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">U</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6.5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">6</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>25</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=11 style="background:#9CF; padding-left:1em" > [Book1]Sheet2</td></tr></table>


You'll then follow a similar procedure to add the Y labels
 

skinnea

Board Regular
Joined
Mar 15, 2003
Messages
126
And halfway through this is where I get lost...

I got rid of the X axis values, and I put a new set of data in just like yours (only Mon - Sun with associated values.

When I add the series to the bubble chart, i get one bubble on the X axis line on each of the 7 columns.

I don't know how to 'formnat the bubbles as invisible', and I can't get the Mon, Tue, Wed, etc as the X axis labels.

i'm wondering if;
A - I'm a bit thick
B - I need to describe what it is I'm actually trying to do, as maybe this won't get me it...
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi

I don't have time now, I'll maybe have to get back later, but try:

- right-click on one of the bubbles of the second series. This will select all the second series and display a menu where you choose "Format data series". Then
- in Fill choose No Fill
- in Line Color choose No Line

This will make the bubbles invisible

To add the labels you have to install Rob Bovey's Chart Labeler, free from http://appspro.com), as Jon said.

Next time please post your excel version. The formatting of the series may have small differences from version to version.
 

Forum statistics

Threads
1,141,019
Messages
5,703,774
Members
421,315
Latest member
awaisnazir139

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