Pie charts - an extra dimension?

[AndrewBT]

Hello all

I've been struggling with an idea for a while, and my solution is taking a lot of time and I thought I'd check to see if it's already been solved. Here's the idea:

Looking at total sales of 5 product types. The basic pie chart shows relative contribution as normal. The extra dimension is performance against plan for the given product which is achieved by changing the radius of individual segments. Eg 20% above plan means that the radius of the segment is 20% longer. So the pie chart is no longer a neat circle and I overlay a circle to show the 100% line.

As far as I can see it's not possible to do this using standard pie charts, and I've been playing with VB. Create 5 identical charts, hide 4 of the segments (line/pattern set to none) so that each chart shows just one product, resize each based on performance against plan and then overlay them all with the same centre point.

I'd be very happy to hear if anyone has seen anything like this, has ideas on a simpler way of doing it or has an alternative way of showing it visually.

Thanks

Andrew

 

[pgc01]

Hi Andrew

If I understood well what you want, you can do it with a filled radar chart.

To do it you have to build a table based on your values but that is an adequate input table for the radar chart. If you set it up correctly, then you can change the values of both the sales and the performance and the chart will update correctly.

The part

The extra dimension is performance against plan for the given product which is achieved by changing the radius of individual segments.

is direct in a radar chart, it's just how the input is displayed.

The 2 problems are:

- the radius chart will have all the slices with the same angular size, for ex., if you have 4 slices, they will all have 90 degrees, and you want it to be like in a pie chart, proportional to the sales
- the vertices of the slices are connected by straight lines, and not by arcs of circle.

The way you can work around this is to use a big number of points to force displaying the slices with the proportion you want. This will also look like if the vertices of the slices are connected by arcs. I use 1000 points.

For ex., if you have 2 products, one sold 10,000 and was 10% above plans, and the other sold 20,000 and was 20% below plans, you just have to add 2 series, the first one with the first 400 points (10,000/30,000*1000) with the value 110% and the other series with the last 600 points with the value 80%.

This is an 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" >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</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:left;border-width: 1px;border-color:#888888; ">Product</td><td style="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; ">Sales</td><td style="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; ">Performance %</td><td style="border-width:1px;border-color:#000000; padding-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:left;border-width: 1px;border-color:#888888; ">Prod1</td><td style="border-width:1px;border-color:#000000; padding-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,000</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">90%</td><td style="border-width:1px;border-color:#000000; padding-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; ">Prod2</td><td style="border-width:1px;border-color:#000000; padding-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,000</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">120%</td><td style="border-width:1px;border-color:#000000; padding-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; ">Prod3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">€24,000</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">55%</td><td style="border-width:1px;border-color:#000000; padding-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; ">Prod4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">€32,000</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">135%</td><td style="border-width:1px;border-color:#000000; padding-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; ">Prod5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">€23,000</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">105%</td><td style="border-width:1px;border-color:#000000; padding-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; "> </td><td style="border-width:1px;border-color:#000000; padding-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=5 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>


<IMG SRC = "data:image/gif;base64,R0lGODlh/AGXAff/AAAAAAAAOgA6OjoAADoAOgAAZgA6ZmYAAGY6AGYAZmZmAAA6kDo6kABmtjpmtjNm/2Y6kDqQtjqQ2wD//2a222a2/5A6AJA6OpA6ZrZmALZmOpCQZra2ZtuQOv+ZAP+2Zv//AJC2kLa227a2/7b/tpDb25Db/7b/27b//9vbkP/bkP//tsz/zNv/29v/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAAD8AZcBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePDWGIHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fKgUCHUq0qNGjSJMqXcq0qVOWQp9KfbriAIAKI6terRpgA4AAJmCoGCAQLMkOAgtwAFAAhVasMD6wRSFSrsAFLl5YGNhWq8AGI8eaLakXgASRGQAARjwQr9gBbUWiFXhYpF/FJ+XCtWx181vJAytz9VrQ7NiyYWGM/hpiQIDWc09HZnzXhWqrFPYCcFy3sW3QlKcKdxp1uHGjn01yTS3y9FfmMCarnQujMNu1s+3u/n0arPXtzV1D/yep3fBI6SQOgB07O3Fwkd95c15MMvlJ9+ZvD4aRuPJj1JwNJlhY7NElV2ToqWdCcgfSFZdvI+Hn33EUDlVchRhmqOGGHHbo4XEXfijiiCSWaOKJGIaI4oostnhUVfTNJ5lpA0jQgVkZzKbXbCiNNSF8FvDY22aaxQVWkR8ceZWRzH0Qo4sxqQjllFRWaeWVU0mJ5ZZcdrlTkiYguZ+Yqa0AQQsW5PajlxYCgCGM4UlQVWRw3miCj3O6ZZVAmz0IV3mYnTVYVfL56SeSVyHaZwZ9sunoo5BC5WaklFZq6aUZakmlmWhGpuhlfSqaQQMZSKDBeJjWxMKqrLbqKqupxv/qoaay1prSq7jmquuur9rqK4W0/voor8QWayyvDySrrLLCNntUsM6yeOy01FaL67LYZqvtttxi6MG330ab5aTiomjtueimy+267Lbrrk/gxivvvOGW+yy59nKY7r78nuvuvwAHrC1L9BZs8MEvHrBYBmDBGR2NNuLIo1xPllQkYUE62FuMaGGlWcd+gnxxdRegCgO0+TLV78osUyvwyzADfPDMNNdcb8o1oYzzUC337LOxMQcds81EF21zhztq/CBgIi8JmsdXCRaCA3IVypPOO+/089Zc6yr019saLfbYRmfdEtZm09T12my3CnbQZMctN9lpn4R23S61rXfbb7cYO/ffgMeN90h3D37r3oh33beygTfuuNyD/xdO6QSUV2755ZhnTjlJiXfONdyPhy664HVLHqnmqKeu+uqsr+751u6OLvvskKdt+qOt56777rz37nvlPWNLO+2Ga3i7o78nr/zyzDevOgjQRy/99NRXb/312FNfPIrHs+n89+CHL77mMGRv/vnoW7899/g6O/778Mfve/r011/9+it2j7v8/Pfv/+b2C+D58Nci/e3vfwhMIPgEyMDoEZBKBjydAidIwd6Vr4EDfCCWIji5Cnrwg6gTCQZBoEFKcdBSIEyhCi8ovRKK64SpUqEMJ+hCnMGwVjPMYf9qaK8bCkuHQAxf3S6Tn5fkiC6T2U9KtAMY7YSqiOF5ThQFRMwWJaomAUqjiQ/FFcQuJi9tDsuKwgJTxdSgpQAKQFBalDay3lAGUJvxkaG6kxo6ThE6jNLJFnfmxT6yjocw0Y5ZBAkdOw4oLo0CUfuSEkYZPYxANbITfwpwAt0MpGJkXNOQbmM1MnlySWAaiZNa4sdSVg6QLkmiGQFUJDtWBwMGAk+F9lhCUwIRlbWi5VKSZjGnxUmUoBzUmdJkAU0Ox5YVxGWsdKlMUiLzfc28FDOjuZNn8o6akZomNo/pxW06SpveDKc4hQPOcZrznEj/KSc618nOqy2ynfCM5yzfKc962rMp6rynPveZz336U579/KdA1xlQTNmnPgrqjY72IoEGhacvnVEoChxKksLAZTKXjIlWIoOfNRYIowTBCkgDlcmSHPQ8B6nAciJkHooWRk4JfQyNBkmdjs6FQXOhKEoNkkhUFnSgQA3nT4NK1GgOtagpcxieDiAA8bjyjGnU0xrJ48tG+kVIepHPJz2mJK5CpwPGZNNRkUrWkqjAAdsba1mpuVUmAdOrpRrVB8JaOnqu9a5AVStCn6TUATBtPTXKk1wOI8lNnscsLxCBXsZkniNqBk4ZwAtkJTvGyP4mOnTFq2ZRotfNetaGdq0SzC8n64LBPvKxleXNXPUSAQv0FFNd+ywEQytbmbxuV7WFUmexedt9LY5ZuV3Kbl3Y25/9FmZMqRk7h2u44urtuNBNFk0apxQiZtYkR3wQn1jCRCBlZyCNcqV4y2hSLJqEuSlz7m2jy96BiWR48iJKI29Dn6eyJapwfGsv38NLOLaSvP+hohQj9Fr0Oku96m0ve+FbtA/xUrtOcyUZpXjID7xWj7Q1J4I3vCoFf43B1NVQfwuCFTv+d8AvgOWDrLYTA8OWwzBmgYf/BWIGE//QxZSKsY5lPONl1fjH9EprhnG54yK3F8hIVm7khhwrzPGkyFB+W5KnPDa84Vg4MoQy4gRG5S7/ra7lsub4OMwtL5v5cbZj8qXEzGbUueoBRxthA4ObkitLpc14Xp2c93w9OnNWzWvOs6Azx+dCQ8/PdQZ0oAfN6MoZGoOIXomdsdzoSrPw0eiL9NkUHcNKM/rSmJ6epmUy6eN4+tOPHnVOSo2hU+MZ1OZTtVFYrSFXi1nWwOJ0mG1tS1wPh9Yk4nUffT0uZQo7iGAcI38apmxJ+kiS2Y2QkHrZU4pVxwINkCNKoVaBpnUblL58QclWrev1HTuFxMZnuXHSV5g2FbBdA4bqbDrQ1AmNbL5AKtTI2gomMp0lrOdW4DnlaCeC78fbUqOaLHOdr7M+JeDyS3dSgH2Sqyotq3mxAIvJFNcGzLXVEG+exO8l25DvbuREobi5TX5KlP9E5eEctMt9/wLzmdtcKjW/uc6Fu+6d+/xROf+50IES9KEbvcU9P7rSdZv0pTudfU+POqSKLvWqB6XpVs96prCu9a4bh+ojImJGbaJTmFjUJiOdtlkhk0WZWHVPBcGkSiQ0dLCLSOx/uU2gtLKYM0oVMIWBqNMapJXDLOfsBYoOSVVCRLjk6UFtKVDi85R4tDwJ4wg9CGAmfwDB06c/eu/7Ta2ymNM0MTh+fzzhreKYxAje8ArivNp9yvWdnTRAZSI9aDx/7bkUBvB7eX3vJfDSB5llpYy3SmX8jpbWb0fyZIFaW+Ry/JjOaDy3/4/09bQf0PN999yvo3ge46m5NN82iaHs4Edvnp6Xnmb72LS7160u//lLvf72fzr+87/0/fN/JtYVE9H2YCrRXdc2bwBCEuM1YBJmGeZVKf73fxqlbAyzIM0GMdC2ULOnXxgzbdGmeNzmbd42EuJmMt9UexLIIvMVRvaFRhrIRr7kRvnxYNIRSyUGYAuoRHkkTSiYgj7YExH4g09hF7PRgAEGSYN0YWkmhBo0FoCRGN/GbdvmJwlXNZdlOP9ByIRMMRm8YWJL4kopFkssBmYV4jAVCBPZ9YEqATIrMAIGdyd+RYCkNYepdYWjpIU1NFyNR1/XR1+S1AFCom0mkV/h0Um+pCiICG5xxABXiIcPlIVFsYOOWE+QOInEloUbRRekNUltR1qjUiphaImU2IMiljGG0kaCqCjnkRutpYS1wjKi+BKViEqIE4suMYvbg2C2uGk+V2S7KCkop2VvFjNMiIu/Ioxeo2BZZ4wvhozE0mPu9RQGA0/MGCnO6DLQ+C5E0WDoVI1eco3+ko0vkxNzY07eaCXgyC/i+DUwETqMpGxL9W5wGG/3JST7VlXKxhlTRVVEEkxh4o/+dh6gmnSOUJKOK7OOi3MS8IUc+ehIzhZJEqOJBzCGClgjJvFghNKI/NZVblUXckeQK2KQLYOQx5VkteJwKUeKgCSSPkOSYHNmHkB7/sSSsOOSLwOT8bUhFkdtAXmKYNFxH5eS+kSTn2OTsYOT07ghGDmRv9GTAckpxHRdWqSS+EOUimOUYYOUR6NBIKkhVrk2WOljWlllN0aVg/OVbIOVYwk4+P/TlRSClmmJkGuJZkK2TnDJN9A4l7JTl+d0l3h5ZHo5PMXjllLhl88FXYEJZEs2ToZ5mFKWmFNmZWZJJdeUN435l0MDmV4mmfbyP5dpXDepmThJhlxUSp95LTQmmmNJmu4DcdfILqqZmEtYmizXO1uWLbG5l+Y4mS5SmwqEjXD2YyKUabJGmCjhm30UaoaGa8Z5EsjpRcpZaMzJmy3ynNAZnSPka83pnNYZRNgJadPZmd15S98pQJdIndU5nuRZnukjcdvJneqZQ+xJnOn2nvAZnzI0n9jjcvZ5n/gJQrCmnzbXnybxnzMUoNi5cwTqnwaaTOVZd+hZJQ0KoMrZfxEJKqET6kEIap5R/7egKpGhDsqhWuehHwqiArehh+aDJLoSJppAv7iiLNGi/7OLMBqjMrpDsVijLnGj8WOLOvoSPApNovijMRGkQmSJRDoTRipyyVZ6gcVUTgVg8qYxmGdYfJgZTkNvFqlf/QaQ/vhv5BZNS7o8TWpSFwhJERMWathGa/cjGdl7BEEfG/mPXiVKckdqF+orY/o7uYWSiiROe3pyjhhQAYiGEwNFKNFdqiSD4YWDjjpgWfGAJBGof2ROVXptG+ePQCmVxJGne4UYzNZ3GBiRepFtW5qoMUgSH2htU/gxijiC8DFuKUGpqcNOgvgY/vGUw6QmKeKpYsRX+diCUVVSHAhMqG43Vf71hY8qYDroipNKq5ejhUnKFNAqrb46FDSYgIRUkRQ2fhZmamNajNcKFASIGJFnkYUFglToGlNjhRVipEIIdtlKHYonRSc2GKHorh0CovE6rmKKnz84rSxinSrqr+0UcgU7dKeWggJrK7f2f68NWzcflLC/WLHuZLEYG6YZu7FTybEeGyUG+7HLGLIiW3URW7LedLIoG38ku7JOp7Iu20wgMbM0W7M2e7M4m7M6u7M827M+CxExG7Qn07JCC6FF67Iwe7R5SLRKq6BM27Q3l7RQ+4hPO7X8WbVWO3JSm7V8GU14d6cvUXYC6KwroR0bSEZna0Ty8bVutydgi3JbyxL2gRZWFBNi6xJnRxPFV3gqkXg2catzC6ktAXpG/xe3KxG4zOYbgJKlBiF4f0IdI7UAaMIXlVQQlXFI2LWPLBWn5EcXNnUY3/EeggIdiKumlqt3AmEACDAQSkJiqLsbKUAWCbEwcfe6Yxe56He6LItNeCcaEdW5+lgBfrt663eu03Z2l/G2JgFSE+IcxjtRKZW8FdeQtvsei7sVv8sf5uG3b5Ech1Rh9Pof7Pe4z7tfrktNhpt8qYp7D+Ugb4G5xEu+KOC3JLgXT5SAS0SvA2IXUIMXH7Vw5qtEbJp952em3be9bBe8yPe9Cdwg/LtiLoBT5XsWALxN6ZsS2Yd8EAZewEEQHNW4SFQQH/wVJWBJtSFTJjNSLQXCife5cP8KIfnWiNmnvQQBewdcGYuLFQs8fonnwCAswSHswZ6ru+iLtVx7nkecsRecxFmzxEwMWk9csU4cxT1kxFQcaVN8xdGSxVrcLFwsa2ZYt3NHJ1aRturahnoXGU4oh3VIh0+ob8q7JV+sau32eHUCWDDVF8Nkj+vHuVDJI2/KpYmiiKpIYDzYxcKxhw4jSTDyhy+YvyFVv9N2j9yWiFLYHIx4yIgsFSsIj371SEv1yMX6SNUhAt4VS4fhWNj7xhHcxnUokJgyxygriZy5yYNqxbYsW7Kcy7GMy7wsE3JkWZsoI5b1icSnYm3py78cSISsiIJcAcZ8KlS7zFNiF01VAYUJfIq+1AGs6Frr/7PLWeeE/EFZrIxarFwXxGcBrfjNykzNZaWHcIeoLJFd21qAGeVEwGFFOSh+gntFbefOLALPTupuUUqPLogCl1qs+GallzqnPYlZAF0lAg2qFiiqaJqB84uuYmylVPUkHyiCr+rMsWqCEX0iE/2ppPxsEVmRYXWrnNSIhrJJXepVThnHJS0iJ/2rEzYYU1qvApyq2tFQrluDc7Ss/NysNz0lDeunSZ1L7dzUAgXOUL1BT40TD+ZK9XxHKIxIUy0rQbiTZJLQMv2TEiBXnGo2uFWykMhLCKfRzNHWr6FwFHlg6YKya22KD52KX6oau1pMdN0zdl3VN3HVUspKyopiKjumr6miN4GtdZ3T2E7nXJA9dBw22TunY5btclqW2cT2mgCDpIJdQwbZNxIo1cPBktE1f6b9FFYJjRoCLv+jqGlwSZLDEWTUGNpneZdG6RQI006rbRSXGZYPkBREQ1C4nTWfKdzYAhRi043HnV6nqdzZwhO1I06/3ROn6TbSHY3T9WXW/dzRkt3avd3bIhN0mTALs9EocURvuIZLgsaZiKukTMzkPM6tfM52ajfgLSziPYzk3S0tMTpIUcedJ5F/BYd5rDTpejGAAhh/nEUL3syVLNKI0VPXfRP9/Sr/3S4qIZhFochn6odmAYgOMhZzTYgHqDEmbocSfigUrgKZfF77LSsZjpobzuEkAWIfTr19deChjNAWULdtJEmJdcrXxlgq5cqsPMwQrd9FVeM2fuMcrpi2Qss0N+PNCOW74y3l60JlynThL6HlycjlWdlluATmLSHmY07mYnlmMjmTap4rbN7mo8kh8f2GTO6JpHLM/4x0cB7nUc7leqmTewzhHEnJfhLNJI1h+wToa37jkMkhBLji2tyPlxwd3Uy2M4HmKOHoj07eqqmUprhYzEFa5mzf6Mxa3vxyWP6Nni7nG56bMcmVrb4lr74r/y3rsD3N8XTruC7dup6Tydzrvv7pLhnsts3O8FTsv26UyF4wZdlOzN7sJPnsvf/dteg07cbeY9ZOM8pul9oO6+LY7Uo2mLVekOEu7txO7luJhefeIum+7YjJ7ty4mH0Z74EeXfTe3O5+7/iu4YC57/xey4z57wA/7wJPNwQfTgaf7y+Z8NU9m+LU8Af/mBAf8Waz2hRf8UJz8YGz8NGyOjax8f4NOh7PlqwZ8l90OCTPKh1/8iEm8So/Zi3v8jAD8+4o8605QfEemjh/3k387kDRRYAeMD8v4DrfLGwW3Ud59KKT8krvajTpN06vmxkv9D6BnFFWZlVPPFe/aw3aW2Xe9WTpQgsaqFdJ5xAf1VjfE9CqOb7FOKupnW3PE29vm7/uOCjKQOFJm3ffPPoOOWfFWffV9PffE/giOmr/Z2/4zoP4AdT3M8/4zOP49QP5Oy/5y0P59GP5UY/5ma/5GTT44un5ygP6scb5nU/6v2P6+0n3o6/6vrP3mo/EYA/788P62kP7fm/7vIP7ue/6r8/7uiP7ge+ehG/3wt87vp+i9Xn8hZ/8J+f7cOv8zw/9rUP833m1KWP9u8P6Mwej3J872B9qA0r91R/+tTr75Y8z6H/9iO+0fNT+qjP+e+ZzOir/6c+eQnf/+B9CAAFC4ECCBQ0eRAhD4UKGDR0+hBhR4kSKFS1exJhR40aLAABwBBlS5MiFE0yeRJlS5UqWLV2+hBlT5kyaNGEgxJkzIUmePX3+BBoUokehRY1aPKyZVOlSpk2dxrypU+rBo1WtXsUqkmhWrkKffgUbVmzTqFPNdkWbVm3VrWvdchwbV+7csWXN4nybV+/ei/9t+f59SFfwYMIy7d4lCFjxYr1+GSsuHFly4cNnH1/GzNVx5r2TPX8Oq9AyZ9KlhW427Rb0atZJKw9MHVt2T9Sz0bbGnZtlVNu9fYes/RurbuK6hR9HXjF4cqPFnbdmHl36culBn1/3XF27cOrbfWIHT9j7eNndyZMMn37uefaZzbcXqV4+WPj1Fb+3D3f+/qX5/efF7z+M+CPQNQEP1OwjBH8qsEGYFoSQLQUj5MlBC1eiMEOgAtRQogs/PKlDEbWacMSQQLzQxIdWOKABhTIIwASMMigABRUGaOAFC2qUqAMAKoBhhRFulACGDmJUSEcAilyIRRczWMAFJ2GAUsrJFqmMkqEPXByJQxUDQ9HBLxmaEgYiWeRxyiNNOPMAHoM8IMuFPvhRITo98ojLhdY0k4AQBmDSzjrprIBQGAg11NCFMgCyyxLH3CjMBiFViEU86yyTTyf57OBNQRt16E48Qb0xyzWJ1HLQHxNdVVVSGXCBJC8pbUhS/mgts8krzcTRyBjbrJHOImlEYc4690TyBRF0RLIhVAmdsspoo5w2VoU6CJREWuOzdb5tSWOUr1m/Zahb9cjddlx0SzIXu3UpVfddGNp1V14V/+O1l17n7BWJWIb8bajaDBrIQIIXMCj2vkexKhNGGS8CWMlsH/IRSCFvzHFHGwH19WE4n6T2SmlFltNOPWvVNzd+QbLUI4sPGDVVIAkduGANPAYMX5Z3BbZYNX8FFM1iVfCTY2MbFTVPXUu+ttlDXWW1UFf/BRXMlFlbWSRUF9r66ZmPNZICCyKwoOrGFr6qZZc/blrGTZHsFIVTjX4oabA/VahUa/FGFOqp84Z1oquxzjojYTs+fE1oSbb2A4PHLjtntK3KtVKee51bAqG5pttrhvhU9nBimfV4cZCtPL3aPSeOaPDPCtdQ5/HC7cp1yWCnUHbc2bVdsN0h1P13hch6p0t4BIM3fl7i40r+P+TXspRHjHXkEWAyGa/ZYIT5Wj605vN7Pq0VIGhB46VjVbvqqLO/GbLunfoe/Mljoz7hoxnqOuo9xSbbbL3eZ0r86hM+tdTvacMK1pIQ9yPVHepx/WMMAA0kQPYQkIIok+BLLljB+W3wOxlsiQfHY0EROgSEKinhdkiYQquBkIXT6eALrZNBGTJnhTVsXfdwiJwb7lBwtvPhb3oYRIpcjYi9GeIRkdItJc4miU2MVIqgaJonThEkBbJiaYOqmMUPPoeLnNniF7lCHzH6JoxlROP3zphGNv5ujW2EY9beGEc6vmuOdcRjumKYRz6+8I59BKSI/hhIQkZokIVEpIAOmUhGDnCPjYSkHB8ZSUracZKVxKQeM7lJSXLSk/Ja5CdFmZpQjtKU7rnkKVXpn1Ku0pXiSuUrZTnCWM7SltMJCAA7" ALT="MyPic">

 

[Gerald Higgins]

pgc01's solution is a really interesting chart - well done.

BUT, I would suggest you give serious consideration to the question - will your audience understand this chart ? There is a large school of thought which says that even simple pie charts should virtually never be used. Adding another dimension like this is a neat trick, but may confuse people even more.

 

[AndrewBT]

Very neat PGC - thanks. I'd had a look at radar charts but didn't think as laterally as you

Gerald's right, it may be too much for people to take in, but now I can produce one I can trial it.

Thanks again.

Andrew

 

[pgc01]

Andrew, I'm glad it helped.

I agree with Gerald, though. This is a nice chart but I would probably not use it in a professional environment in this case.

It seems to me it does not convey the information in a way simple, rigorous and easy to read.

For ex., I think this column chart would be preferable. It's easy to see what the sales are (in green) and what was forecasted (just the border).

It's, however, good to be able to choose. The other chart, even if it's not the best for this case, may come up handy in some other situation.


<IMG SRC = "data:image/gif;base64,R0lGODlhLQIfAff/AAAAAAAAOgA6OjoAADoAOjo6AAAAZgA6ZjoAZjo6ZmYAAGYAOmY6AGYAZmZmOgA6kDo6kABmtgD/ADqQ22a2/5A6AJA6OpA6ZrZmALZmZtuQOv+2ZoCAgJCQtra2trb/tpDb/7b//9vbkP/bkP//ttv/29v////b2///2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAAAtAh8BQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePID2mGEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIPyFCi0qNGjSJMqXcq0qdOnUKOOJApTw4SSGwQMABAhxYauKTBQIPl1pNiyYSmgFSu1rdu3cOPKnUuXKdW6JgHg3cu3r9+/gPFycHm3r97AiBMrXsy4McrBLQu3HAHBBEkNBK9e1pyCsgkUFkB4Bi26MumUhx2rXs26teuikFlK3pv6tW3HtSPf3u049srZeHPzHu5X+G/iyAH7Vgl8JYoKAsGmsDpyg8CxJBqE8Hq9enfuAMai/05OnnZM4+XTt12OGj1d9+rj2z0vv75U9iibpxyBYHv1rtmFcJpJJCwgWn8FHhhCgvz5dxJ89kUYFIR5SWihUvg9SOFNKHQw1IUgFrUhSSOGaKJMGeZVYlsrnujicTC16FRIFb3oUool6YcSdSZhNtZa4nkF1llDqlXkeDYmSdOKMjYFgARQRinllFRWaeWVVTZ5IY4kajmjkmDSF6NhWJZp5plUeikhl1OpOV+YcMomJm1o1mlnlnGexGYKOp7kWUkjEADCSTx2ZlpooyF66KD55enog3MGd+ekd7pp3559xmXpo6w9aaenaIJa56bnVTrqpKTGSCNFNWGa6lGvclrKmKhn0lqmrWbGGpmpoaJqF6+9VtoqYS0+Fx0GmYGHnXbKehees0FCKquEuGJZrZXXXqmrbMDm6utS2Wb56bczuQrYttMGFm6a4woLbre3kpvUulPSG6W9Umr/aS5MDZZEggIGbDegvwY2yCCCBfeHZLr14Qulww4//Gu7tcqLVMQQWwzTvkF1+OHFkTIsFMYUjzrxqcF+enLKFbtbLrHn1kQyyiqDu6pEK7fMcqg5e7tzrT3HS7PJNHHsUqEkBSikWUEC6fSRjS4Jr9A1KxUxpVXPO7W1Ghs1s85EW721tl3fCPNfWn4NNs/vlkx12Fq7/TbbYstNtstxD+1z1jEZzVfaY2Nb9siBs4v3xYUbzjesiec7+ISNO374xmfX9CehnCVa2meKcs6otDOpvTfciNst+OReR37v40CJzjXqIqr+MOsq+W2e1KafvnjquStOOuO9+0533j/f+b177MHXS3tKtgcns+wSXI0uc7JLH/Trxd96vfGjD1+63nMDXXTlTBnLVbMLNxzh9GivTy35Iscv//yzsg/Y5YZaNt13mAVQgHhKUwz+LoeZZ+3PfxRA1kA4g5gBVmYkBRRP//4XFoEwsIEPHAkB+QcABG5mMQ7UXwQh2EEKKvCCT8kU/VbIwhZCRYUujKEMZ9gTGNLwhjjMoWzsp8Me+tBRNvyhEIdIvyCmwHxdOSG0UqA06xjQieKBInOISMUqwqV5deGhFbfIRT3BjyX9AtQArjKwpCVsQWc8mIMq1MU2ujEoWNyJx3aixTfaUYhxnEsd72i1kPFRNf95xFyPJkAdIJGlSE9jWvr+iBs/MpIxgdTUI1fDpEmuJpJw2aMlJ+TITQYGkyTBX0mQVijNmXJRi/SkujqpSr+A0i2abOXHXhJLWe7klSyyJWIq+Tes+VJ7ssLlEaFzPiU2q4nfkSL6oqbL9o2pl7+MZpqmJcyo1LKZNuElnaTJTYkF84srCeN0uvIcCpRxJGpM5xlTic0ssjKT3ezmNS8JTp7MUSfzxKbrsPc73sUzmvnsTT3f084ZQc96bQMf97wHvH8CdFiRWRHSkqYdQ/6HaYlMCzsL6s/s6a6fyFPoRxna0bWFL1cQ3WHMOJpQj4oLdoRL3upgCjmZzvR4Lan/5gtZ2lKT8pOkIXWp8mjauoMu7zEDRYkomcisUWZuUaf03EZ5WlSbzo6oP9nnSMVXN5FuFaXji+hKQ3cznOlQq18FZleFKjmc1tSrL3XrSnSawudZNXpHHYpDH9rT7p1UrcTzaVqttb3BxhWkOU0qSpCIzqZKEZlPTOZ3mCkTtB4WqDGF61DlmlWjYtUnlt0sYt/K1raOdq6KlSTuNCtazJJWsJflamD9+lPZfq+0V+UsaD2rW6SK1SbiPCcT00hcBU2VW3dF6FphKzzbNhS3uT1tZ62q3Nn+1bDYSulv2HfPnAAuuXmlY/XCi0/eSne31CWvd83rWtT+tjh2Za1pGNs7XflGl77ote99nVtS2mIXT329bmzB+v+y9y4FaRYFXWXZy9+gMre1Dc4sdPH62RqOt8J6BS+GTUJXqnr4w6lNzp828AARCKozCFPQCAYAwKYmZsQlPrHBzrjiIAXwxQ8ksYkHNWMVs5iE0cKgZXQs4xQ3qMbTISQK/wLjHaMYjT5Wi1bOx6KAgvjKjzQilrfMZT5Zuctg3qKWw0xmjo65zGjW5ZnTzGZPrrnNcGbkm+NM5zcGMbihMaNx0VncHouzzoCO050zOEjNhRKqiJYqZQPN6OF02CXdxcmXG01p2IT4LZOutKZ98ug3bfrTgLw0LEFN6sbgcqJWKeSUpbO0tGSULYsutaxdKeqRMBaCmlEiZKMoWQMixnrWwK5Lp8EVbJm9s9juVakzkX1sNjK7b7WWSqa3rM1nv/8El3/uzBiHu2du+9nICvu1tY+r4HGzBNuELqAFDa3BRJOG3eU2N7mdLe9kb7cokb7JtLFc7XozL9rW9DeMaClwezNn33IquLjnXe9h91Hh8R44xEtyahT6yCurxgoiN67IhQu83xNPgTAZa0xdM0uZKJ9sxBUO8ok7fF4hz1GzGw7wncZ8KjOX98tBdnM+5dyae/0lwpVTa3GWJUBq1PO3oZxtEvXc58/cZtApNfS/oFt/hUZluz0XVeHivOctl8vVpu5NTu18sR6i49PDrimyU52aNa8r2H/+QrerF0Rn99ra6Z5Cu2/YRHkX0d6jLim/n/dFFUdJgLKyFVa/2khWHV95wdkOT8PjF/HRRqICLVhBAFxl10tcpuQ/zneDWj7CYAr8yJAdWggT2Lq1XSjqlaR6Tha79fOdfX2hW93bnp6wYVU2fG/P4Nf73r8DBuzxBdxc41P/zsCTCfc4h0mBpPNZQersNr1njfubHj7D+u39cx/seuU/X/guEWWgGAXvrnfO61APdvf36/z+Mj/39Xcw8pMP/AKj/yf5lk2sV3zmZ3+x91/TFGAHiID1ol0HN1bANn8U1lvgx3t3p28E2H8oEndfQnwaRoHilV5/t14f+H0cxoFOMoAleHkVSH7ex4IhqF8TaIIUV2sTxVTbwXhUdlGuxnEa5XGbJoHiZ4CyV4QFqH/3h39HmFjQ1xK3FkAml4O9xmu+Nno1VHo+JIQXmE0XBoLltYK6929N6Dw8R3B/pIUjKGldSIMkKINDaDZj6E6rNWFvGENo6IVtaIFpiIFg/5h/TPh/txM6GagthfV7ZQd7RsiA+VKIzaeI98KI5eeIhwhtcbgf0sdEALMd1udt4MZ0lyhzc+iCLxiGFmaIGrh8C8h/hKiAidiIpzh+++eKq+h/98YvhNZY29F+7vZ+eQaE1NOHS/hasaiEr0iEjliHwpiE9BeMVeWGF1h7tpZ2+BRfdLiF1CiKMwiDX+iMe8iFIoiHagiMxQiHgEiGgiiOs4iIioiMzViN3XiNwziKfpiMqSiL2RV8tTh858iN4MiH4WeNoRiP8siMu4eN7FiQArmM4/iH+WgY8KiMCpmOqNiKkSiRsAiR2UiKLZiQB5lf7tiPj4ZgGXdIGOWDsJNmhb/Ij2wYjv/4jgGJkR1Zii3Zj96oktpIEp1GcpwHeuijTL6IGoN4j8vFkQC5jx+5kv6ohzT5kPVYkUK5gZWoR0xJkU4JYEMJkTG5kTBZlAv2jUhZk0d5kyMBjVk1lcfIlaXilWKZlNiYkfPYjgaJljESlFYJleUoh0bZllkZg0r5lWapivZYlxO5jnJJS3SZgLT/+IBNIU6buH1ziY5POZiASYwWaYyTSZmReZFNOZALSY9UiZmCeX4NqRQhBH9VR2z2cZoPpz7uE5VP95rkMWewOZv1cyEwhnUqUU6YGDAglGMPgJspUU4aQE4VEGT345vAuVjFeXQuJmRe8ZtOWJwatG0ChJzRaU69CEuquRQh1GpiwSOwdmPOuXXeSQHgORbr1xjdCSTn6VS9iXUjViTnqW6eV53wmWPymWvRcoNOsp20+Z9Z5Z8AOqD4JKAEeqAyY6AIuqCqwqAOqhplFaESOqEUWqEWeqEYmqEauqEc+qAeuhiy+aEiajMjWqKGoaAm6qEhmqIsCloo2qILuqIwETqj+vaiNDqgMnqjOtqgO9qj/xfTIismEL+pQLzpk6GXclXoowRqQ/8yEAHQbbrIdbv4OUqKoyXSpEJqGSdgGRoAeT9Yno+nIgLBAWRapmZ6pmiapmq6pmzapm76pnAap3I6p3Rap3Z6p3iap3q6p3zap376p4D6prX2HJrhAWjRpZuYfUvHcFX6aWSZAhmwRvrWqNb2qFdIqcxmqbOEqcGmqWrHqcXmqdMIqp2Kgp5GqrImqt6FqsAmTEEKANCZZGYhELxJFlMYej/JqoD2SljaQYMCGg5wFU3nfptjmrqaqqLWq7/pGTyypdPRNCbppSfZJhxardZ6rdiardq6rdw6poNaAYX6QYdqY33WiYx6rDZx9qiR+qno6qimipo3Z1Y9p6qSNnhmOK/vupoxR3kCR6+TOneEF3P+KoAAe683N7DGVrCE8Zr/rroVsCpCmmGkPXmr52pt/OpvvKoATvqrFhCs+TMwxApvjglxF0tzrukvGpulzHoVCfZ4CUat3RqzMjuzNFuzNmutuESoI+EBH5So5eqJkup0CqsbT6euQZuw8YqFyIawS2KvC1u0+QpzQ5tw+HqymeS0RFu1d0lQUytxAhu1ZbivShuqYAsrWEu1Bxttrzqk30Gka4SkVGicQpu0ARtyGbuxFBUCwzqlIguKdGuwX2u16JSyD1sSbOGsXUqSPViSkQezN/u4kBu5kju5lAsAOQuuO5tRiXt9S9eYfiu2detyZYsS6zqqf/u0WjuagQi6gGu3oyt4XTtFUCu4oxa7IhVbqa+7erabq+bGtKFztl77HqbYmbSXu7Z3ullbeMMbmnH/0rBZqkBxaxJwi6soKW8lK23Lm5nNm6yE+6R5G6XvNqW3y2zXC3TZi5iPcrdZarjSCq2Mu7hf6riVO7/0W78Ncb5pYr8TermFCiQ+i30/O76sN7ZXmb02ekXGSxKlu6q7W73Yi7+L+E20m0sNPLJiB8ERbHYJXJYV/LlZhMGPKMFbK5UdPLfKi8EH/Ba+W1nAK7tSh8JwN8HS1sICDImnl8JuscIEzH07LJmGiMProbYO+wAlQExDQqtvS7ES68ETV751B8LRE8MjTCDdS6VWsbdSmsXGWsJf98IQDMT3wb0DEasJMhKI677wSySN62X628ZubL9QHD1vfDP8u7NGhAcWm8uJQOu5JhxyTtx3UAzGUWG07BqB2WrDlifIUKHDoUtqd+iXL2ktEFGY6cHIrVtqj7yWYBmXLnkpGwxaKmiTGsmXnLyUkWzADtgeEMh9h9mArEiYndyVgZzK+YGiiixEmTzK29iXmvyX+TvJe2jJqBuBrZzB6niZEam9SLiZnFmZ5P+oumA0xEUcHdQ7sZGVpEyMycUcwgX8mcnMvMvszd+MvpQ4xSiLt5sBvrxYrNlpwaCWy2+JkFhJybsCmeDMkIrpEsqqP2XcstH6smw8xwJdrdv8MBW6hqFy0Pb8yxJRxyngAYy5TpzbiXzcxcS80K7czbBsynmZkG5JkGJozjixwPXqgaIczx5ZypDc0VsZzJ98qfJX0FH8ysj80cQrz8w8zhltl9CMlxd90iAtk7ysy3mol8/40pvKyhhtzD5clc2szBJm1C4twwFn0mFJ1Cw51Cgt1FINkkhdyEoN1Ded0kQZy2kp1s6Mz6q8bD991VutlTm9l7vc1UjpvIULhUj/jBVKrHLu/GnwHNRwLc5yXdQePdhjKcYC8aQocAEfwCxYHL5a3M7Z7MgyHUvzZ9hsWdhHTbv7jItmzKVorMZpHGQDXdocWtkKPZOjktpufSsU4dA8i4OtlseKaq68K2kRIWeVjcg6bdNp7ZlnOdUifRMk/a9m28hd9NdjzdVlzdGy3NrL7UVUbXPHfcltpNy/DZfNvdLPTddrKczJC7vWndy7TdOB+dT3DNw17dtQfW5fbbrdrdlmLWjlrdE1jdmbLN9ePd1yx9I5zd7p3ULY3d7aPc/zbZhLzc08nc8OecrB7dxnDcPm7dToTc6aKdj0jFxoTeC1894M7N/iDOAWFG6ZP8zbIl7hO93UoIniTH3hD17X/0K8vgEksdMren39G/V9zCU+4SvO4gqu4iyO375M4b3946LJ4CzRq4rN2I6tdR+7zn3bx4+54QGO08tr2TkO5L0t5A6+3pitvoUr2/78vqI9rQFdEahNoZUCzJ/C2t5dK26+3Qmt5glu0BMB2579v50r0Q78IFnu4ved4The5zNt3+dd5JMI6IeO6IW+4GstFMVNsCD+4r3c5YvO5ZPu5YKekloN2KSs3zDO3x2Y6Yt+4i1O4kSO6fHd0hA+5Z0e3Z/O6qE+3LVL6kRu6kaO6j2O64mu6z6u6hGu0pVu67vO641ezj3NtcT+65sOlGqJ1Zkt68O+6nHd7Pnx59fm4f8lvexFDuyuLuzQnt/SHu5DvuvejuBUPuLPjOSrG+ygPu3ubuCtju7Qnd1WvtHcHe///eXabtzUHuLnThgITe6WfusBX8+qDe/f/u7Q3mlrawJuq9fXHL01POBVTtbynu8LP+5vHevVfuACT+j6woFKrn1bB9koL9lSTu9v3vFzLecEz+24fvAa/ur2jvH7vtm0fhKdfcaKW+btK6YWkeYTOvC5Eucc79p0nvBwvvT1ji2vjYI6+9DjqnQUzec3zukt7+kvn/EKz/IM7/KE7fUx/++U3vCfHOlIa/aaDvIIb/McjvMAb+1+/uxin9VbD+s1KOopWPDFTvODzvR3H+2QOe/2NQ/ugy/uhb/fOz/Dfs/shh/4cH/xzJ30ej/2Hz/vIZ/uKX7kj97gMp8xka/1MJ/45Q75mv/2iM/1mD/3wp3sJBz6d9Xr4YzvX7/5T0/5gW37Za/vrs/4sC92p9/tdJ8XRs/6eB/2yE/4GD76zs75p77un/83wz/zxZ8jx3/5yW/5N1/5ma/xYM/9ce9b/43PEw+/xCuP+3nf/bsf6M5/7SJv4vgC+KQv/rp/gnxfEyUf5Rbt+wAhQeBAgQAIHkQowWBChgVTPIQYUeJEihUlLmyIEGPGghwTArAYUqTIjR4VmhxY0iTIkS1dplDJMSbDmRlZvsRZsSZNlB17Osz5kENLADeDHn1IQkFRAA9MbIjwEAOFi0ytXsWaVetWrl29fgUbVuxYsmXNnkWbVu1atm3dvoVLdujIokjtPkRRYcJDDyQWgBiBIITOu4UNH4aJWPFioowdP74IWTJjo5Mt362sM/Nlzp09fwYdWvRo0qVNn4ZYF/Vq1q1dv4YdW/bso6pp38adW/du3r1d2//2HVz4cOLFjecGfvzoiAFFA4BomZdqChINBvtm7hz6SOl5i0YNnh3A8+gVqGIoOh178/HbRUqHqGHveu3lzxc1cL10cuU5R0AwIYX/REiAgfw0KGo+BA9ggAIULvjAuvAAFBACAg0MAUEAFASAQfVSkG/CAAcs8MAEH1qwQYiq04+3/0a0sMQMTwSxQxVRsMCB+Xp7scILTdwQRRspCKxF0/jr7yXxnusRKqkoCDGFqZKSkL72mgRvqiinpO4v4ZYEjEInpYRyPi6fDI89JsXMsswnX4ySRzXDDHBMLc2k6oQANfhwNCSTbKnHh3os0i/ABFNqOhZFhIhQRP8qVAF7IgUjTtAKR3z00BAStbNP3Sx1dFNIEZU0vh1dpHBQCgsddVNJx+TztD8BpbVWW2/FdbdZc+W1V19/BVaxXYMltlhjj+V1WGSXZbZZZ2lT9llpp6W2WsmitTZbbbflliJsuwU3XHGR/XZcc89FF9By02W3XXdxW/ddeeelDNfPzerFN199OwMgIAA7" ALT="MyPic">