Spider Chart to look like a target

StuLux

Well-known Member
Joined
Sep 14, 2005
Messages
603
Does anybody know if there is any way to make a spider chart to look like a target i.e. with the centre rings of the chart shaded red, next set of rings amber and outer rings green? The lines and plots will then be shown to fall within these regions indicating whether they are Red Amber or Green.
 

gramit

Board Regular
Joined
Jan 8, 2010
Messages
158
I have created a similar chart, although I had a fairly large number of points so it worked well. I formatted the grid lines to have a custom gradient fill set to radial, then all I did was play around with end points of the various colours to get the following result.

 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,748
Hi Stuart

I tried the following

- started with 3 doughnut rings
- changed the middle one to pie, to close the hole
- adjusted the ring widths
- added the points as a scatter series


<IMG SRC = "data:image/gif;base64,R0lGODlh5gEmAXAAACH5BAEAAP0ALAAAAADmASYBhwAAAJycnIaGhv///1BQUBEREd7e3qenp+rq6gsLC62trR0dHcnJyRgYGH9/f01NTfv7+3Jycp2dnaWlpYqKio6De6B/X6qJSamFTZKSkioqKvf39+7WwuTDo8inZ7+mWq6sTJnETJLQUKC6SsanY8+rc/Xl2fz28uC+mrGqTqeySrinU8upbefJrfX19TIyMh4eHqqvS5XKTpp/Z7SoUOrPt7umVvHdzdKuevjt5daxgdm1id25kZGCdquNSZjETJy/S6O2SsPDw0RERIeHh6OuRqicRIuFgSUlJZSAcKehRaO1SK6oRceYTNSZVuKgZc6YUMGaSZy/StucXeSjavrAkPe7i6ewRsKmXqqsRsWZS96eYvGyf9ebWr6cSLClRu6teOuqdLqdRrOiReembvO2hJHJVYWXe3h6loGRgZDFV8qYT4y0ZHVvn0GIxR+c3DeNzXRuoYiva3NyoBCm5gCw8Air629yo4++XLegRn+PhDiMySuU1HyEjaC5SHlzmheh4Xpmn3hrnASt7Xpin6SAWI67X2xzpWN5rYywZoSdeGpzp3+WgtCZVI23YX1goPK6kbiQmYx3oqyKm+63kdqolH5upEOIxnxtptGkl31wpndxp+exkqiJnTqMypuAoIZxo35mofucdfuofoFqoXxioP1mTf08Lf4wJP4kG/8AAP1INvxyVvyKaP1OO/4YEvxgSOKuk3Ryqmp4sdallFlZWfq0h/xaRP8MCbqVmnFyq6yPnv1sUf4eF96rk6uPR/yEY/cGCrozVI1Th647YPMJD6eCUt4YKH5emEOFxHxfm9QfM31emHdjnesPGf1CMvq6jPyQbKo9ZDqJyJxIdgYGBodYkH5fnPx+X4FblnxfnvuievuWcf8GBbo/XYx1oPuug+YSHnRkn2psqNobLb0wTnFmoq47X+IVI/4qIGpyrK4+Yfx4Wp6AZKuSRqqVRaqZRaalRfxUP/4SDqeEUKWCVv02KZu+SqmITJ64SIiIiJWVlY2NjQAAAAAAAAAAAAj/APsJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0KMUA+pIqXcq0qdOnUKNKnUq1qtWrWLNq3cq1q9evYMOKHUu2bNUABfUNWMu2rdu3cOPKnUu3rt27ePPq3cu3r9+/gAMLHky4sOHDd/WlRcy4sePHkCNLnky5suXKigmqvcy5s+fPoEOLHk2abeaBm0urXs26tevXsAWfFpg6tu3buHPr3l14dr/avIMLH068OGnfwI0rX868uXO8yJ9Ln069evDo1rNr3879Mvbu4MOL/x+v9zv58+jTdzevvr3798XZw59Pvz5r+fbz698/GT///wAG+Jd/AhZo4IFuEYjgggzup2CDEEbY3oMSVmjheotdqOGG4FHI4YcgDudhiCSWGNuIJqao4mgorujii5hlCOOMNHbWYo045jigjDr26ONgN/4o5JCm8QhgLQAYwNYBADSp5ABMOknklI0FiR4CAByAxJMMFKCkPkMM0OWXYVJpZm9G/oeAl2tFEMFaayLgJpxsnmknYFamh8CWa+kTAJ1yHgAnn3cWyleeV9YZwZ9reeknnU+6NUEfFfShT6WYUqppppxu6mmnoH4qaqikjmoqpmhUUMiqq17g6qsX0P/D6qr6RKCUrUnhWuutvOba666+BgvssLoW+6uxwiI7rIWInhdnn28OsOcAc0qLRF3JHRpYtntxywEKHtiQhQwyiCCCGeiaq+6656ZrhghLZOEBDi3cEBe3eeGb77bMpvlfnWNSG2bAYNbVh2AHA5awwmudAG4WWZj7rgjlsmvxxRibK0MWNnjQgmn8hjxgv5oJuGeTAJQZQZPX9tlkAXZVIJjMgNEMWCEeRCxxxjz3jPHEG3swg8gj40kyajgu/JfSfTGd18M+Ry01z2aQS3HHNfSlL17R/tV1hM1KaPNfY/dVtl0t2HDP1Gy37fM9WHCg19d+bW2X3QKGHaHTfPH/rZffcN3gwdpuF264xeVmUUIOiclGNIR6Q3g2X5PrVXlbJuig8+Gcd75uHjtg67jRFUbeIOB5oX4X6jXY4PnrsL97jw323isY3XzhzqDpDF6el+93VY7C5rAXDzvtcOne7eMN8r6g6qsH5nQHEU9s/PWv55F1W3iLTrqEziMI/F0OBFY+WzsUgf36xb+bxfYDdE+X/HLRz59v45MI/d0h73CP9ewLIOeqtjEUxO92gVEegsJ3oPMBxoF+cQAHxlUxAVqwc++yQRJGVzTwFWR/Icqf9/xyggvs7IIo9JwMPMC85ZXOXysCIV0guJcSEC6FOHxdFj5WtxYuCH84EuH8//pSA+Ll8Iids4EJ+qJArh2NNkkTDA3tcgIbkAuASMxi4e7BQhd2EGwfxNEUtZWXGqwNi1pMY9vMkIUTlMeHC4ShioQ4lzHKpQRXVKMeD3cPHkaPYRWqQEHoyCEZzqV7VTzXHhd5uC7GLDCEdJAcU2RHvVSyLRy4ISM36bYsLNFg0rNQH8LIoCi9DAEDQALKhDDCL8alBJyMpeHuYUC6RPItt8wPA89zgGi9AJXkk+JcTpAHNMrymD5zZFwMuUwLCZIguazPC1g5gCFEqpU9jAsCjIjMbvrMBnOJJlvESZ9djicAZUKABl4mlwB0ygEO0BQ85RnPSs3Tnu+Epz4cUP8BJnjzn1MzQgVS5al6nuqglbLffkZJEGbm5wUMeIsDynRIhAVOkwDNaMaywLi3KFSiT/xNhAIAs7ccgKJyuSRezmZGjbq0Zxz1KBwP9MyBkNM9tWCUWx7QxD5ZtC0tqOBLh2qxe9SOLSq1S1LzNkkACaGkazElSlM6s7agQKhEzaq67gG/A35vb6Sk0UffsjAUaPWsRYXfUmcY0rFaaK22XItZ0UrXrdbOrSAL5CBxhFe2HKyldQ3sPZYIV6q+sGQ1KqxcKnCDwDrWXG1ULFz6Oh+GDsShGqLsAJKA0ceiNQs3lax+zCkg0brFBOrz7GPh4UZXNqimArkp5ABzgiX/ZLUITPBBE5qwhS709re+7UITfCAGI/wgq3l4YFvFCJgsGPOYRhCDb6FBXepW4brYzW4VqkvdMnShEWJIbUbBmU0JWVYgmL0QXj0AUHhItwzc1a5853tdaNSXumAAr3iRaYbQ9cW09iFtgAA8V2QaoQnVpW99FYxd+8rXvtUFQxP2G0sZHPWNeoUmX/tigs4usghNAEOCGUziByu4umT4xXFl2Ua+ALg+AgaQabm5RyOQwbradbCJS8xgHTcYGl3wZyzJi2HzhnVGH2XvJn8gBhH7mMdQjnJ2qbsFI3Cyv3t5cTmbWiLJFniPTHbyk3k8ZimXmLpksDIjLVzkCMG2/x+ybZ5eOsxII8C3zGbOc4PPDI0tUDiNLcaLlucT4/8olsZILMIWcKznBTfazNRtxIqP6AA0oMEB78LCvip03n6kl1l52cEe7yEGRj/61I6OMjTAIIYc4sEcyQAEIPhgDjmIQG7BPCzSGHSyJlEzACi7ZlzgeoJ7YPWIRgADqnO87Dz3+c/r+4E57FCHQVh7EObAQxag48y9NsiabSHYVCeLFyzoEcHNTjeee4xdLqhZgA6AwyDqQG9686EPWFbqcnkNbrZUa03CBqldOHBsHCr6yetWdbohvd1GWPAQdJh3vavdDBHco7VD5PSREfQCdsaPUS6oU/3ugmgU2nnhC/9POJShQQZow44Z1J64tSsuAyLXcd8RikCYIiABQMElAA7Y56UQWog0+sDBCF+2ylE+3+7Cg3194IPE6w0INJRLBjNA6Kfr8+Y4t0cIYarVoFxAF+gVW4tQYDrKl67qdxsPD4eYurUR4QiNbTuuuoaihIbwpoBNtC7js8FzBfiDLiR9z6hmu9qb3oT1KeIQb5g3HRChCHb5Vy5bp0+nM68eqZrG42WniwkKbsEfUEHxiyfz2qHReOzhAQ3NaAYzbL0uMywB7x5ELI2AJ/gj/mDR9NUx6k+c+kZDw+HrI725Lg8XzsOn61GUy+h9T4Xir53pEG49DmVw+8XifEa+UzL/DgsPYesj3vyQ1j4Ome8W579n89GHy9lzCHz0N3v4UqbuL3Joe8Pmfte7JxceMHjrg272d34HyG4N1mo5xH55JTbeRiN+M38pJAYJqG7mBw1ud0HdJ3D/p3c0YkcDiENGgHQXiH8XWAVckA851FUPCFYNtWFvQYEXdA9cgIIpuGPm1wU5dHduMWjwUWj8MUZfdkGGh4Doh4MnyIApdGE+lWE2JYNukQc4VGo5eH/2R10utz7KtBZA+B5CuB9ThADKdz1FYGopqIQnCAY4dA8ypXExWCPJgQM4tGhqeIVISGJlsAvf8A2fUAb5Bw0+gEN+5IXfByNTVHLXY4V4mGrW/1cJmAAHbzBrmJAJkCZkF2RzXgWBGiaHbtFYKHQPytaISgdllNAM83Ztg4AJO5B/PBiKGDcAX+geYagfNGRuKNQIJoiHdwhlkwAH1VZvg/AGnzB80MCEFsR8mvV+G/ciwOFh2HOGpIiFPEYKdDBx1TYIzZBnYDBpAcRGbTGLE8JlJAJBLZBCRziN2yVfojAKKNcMESeMFId/x4hCMoBxy+ge0OeJbOE6FySN2AWIeCgKvGAPqdALqpCQCpkKqfAMvOCOzMZjn8AH2DiMkqBn3YhCJYBUh3ggK5Myg7JKdQFBilg86diIrfAM86CQLNmSLNkLtyAKlGBmviALU0dviP9QCShYj5n4ghACf7xWC2uBBIzSb/zTMCgEkDkIDWUACy75lFCZkPPACmaWC7IACNVGB7MwCUqYkRbkhoaYdyK1dz3nAr8kaGzhCyh0ktfVAb0IZbwQlXIJlfPQClLmC9/ADMxACpVwajxpQXfVbZ0IIQC3Fh0HAAUATG8hAUEXdPvkAPv3lcK3juZXBq2wknOpCucwDMMgDcWQmaggCgqXbmx4QRiABvvUkQgyBIKSIOP2hgMAjcZjgAkIDaiQmaqADrAma3DADMuAm7Bwgtf1dBYkBk9oZHHYINXiFic1kmuRAyg0igk4CgiZmcHADKpobePwmZn5DAKZgOrHPmD/KY7qUYvVwXdxgZ4ZR4cWVIJvGWXRgJsJKQ3ylp1vQA3y2QsQmYTbhUJyk4/tsY8LwgAoA5KeB3hrgYzs0wgX6JTyqQrWAAjXlo2DwAwPqgrRUJsbiD0rJIuqGUNrIZvFI53ohw0XqgrYeZPWZqEPiguj8J3WB2Rl+DrgBKDqAZQBeAIXlAXvSWL29QQnqgrUIHUyBwjDcKHB4A19+IcZKKKv44bkmR7maR8Hc44WRJvWBw6YeaHOYA7WNnHjgA4Pig7NMA2yxgfNYInWV5KvcwI2mh4COiPlo5YWRKLFZ5tBmpDl0AxYOQh0MA7S8KDXqYrVJgutqHbZd0E30FMF/zKlMDYA/hhARSCQPUpft5CnCokOw8AMjzAMYvqg9Pml9cYHxVh8pSlAO/Cm6IGjSDYAVChAFliZ0ICptMqSwxCPwqiNdwoNW/g6K6Sq5+Go9FE+tiVAuoh+t1mrtZqiKkoKlTpfxBlANgCs5BGnMKIWM+o5drp4oqCsyjqkcjcIgPAN5hee2ANaH6oiDgCKAfQDMJp61emtmNqlolptiEALzypfZPCV7ucerHqtRXiu6NcK8qqse9qngDAO55CvOQYNF7RBYkmtAwZLsMqw2vUMBausmsoMzeCpqsAKFttgTuo5QwOFscVX4sc+CNYB1ocLGfuyqnAKGbih10MP6f9KSZHKPkcYskAKsy+LfuZas6LUjC6iDzm7PuAQo5fqsxlrl3f6igFksxErRkd7PT8Qsti1pUzrrc9gflRgQRcgmFEoh2zKOfdgfuCwtRnbCzG6rwIUtlObWGV7OErJrWpbsLhgfqfKPr8wtMlpIaYUcB41t4ZTBOZHsHcrr1hbBWVgQX0btxbyVEryd2U3spzDBIvLCokrr/u5eA4rQEYgtid7IdUScoLbFhVguYfDBObnoJtbqxlafI0LujeLIA7AKM8yF32QrZxTgtaHsa9bq1RpfaprOEYAAXB4WRpyu5Dyc5tSnOYHvMGLqcObetBQvIVTBLXrkdEyLfPTnov/6wrTS6tOa73Y6zahWyEOEIEVIm6Ad75tw7rF1wGuO74n+gQx2p7beyD6AHpzgQYsGECYa32aa79BCg5oiHLtibwSsr5/CyP9JECGa33xacAnurhc4Lj7GyIOQLiFkw+LOwoWfKF5a317uz6/wMAwOLZi5cFuc7Z3WgYj/KBsK7snjD2P+4FjKYFVez0JjHLxOsNyCQssW3xf+7YqLDlEuyL68KoBRAbWR79CnJmxa71BazxSq8MSCyAVgIsB1AXmJ8JTHJUlbH0Kij30kMSnw74w0gcpW4DvqnZaO8Ys6QroF63sk8VgpHvgR7EBFKvWt7R03JLlW3y8yzkzoMYM/+LAylsjfWClAQTD1tetg8ySuBDHa5fBFsSoTMXHiAidAnQPi3td0lvJ1WvEX+l17cHIoxuA3rg+1Wd9ZSDDlawKvVDEd3rFxZMF/TqOnvwiB+PCbtME9ifIdFzIxSfMbWMDUbqqSzxHkGpBWXCAwTDIqGB/ZQC/beMBWxwewlpZA/DGHMqU6FfAY7yti3fEAoQCzXwe1voiMiNqFhTL5tcB4jvFyGy9Z4w9JtDNHUKOIXIwHHBBjJiByTrCt4DJiKrMbPMDA4AGftvIIbgWOzrK2AUOzjDC13yAmizBA6DK5QnQILIZDM02UHyAlGy/zmDR11UGyCdA4NTO5MHKcP8GIR85BGSXSiJJF9HixX98gaLgstPbCyxdXyU9NaHTyyH9ywWCAEKZSn+CAEbpPR1Qg0Xd0qkQvK6g0Kl3w+vjRiCdHjSt1OhBAEV5uuQ2ACfwyrCcgmVQylt7ylmoy8WjvR4KuQ3yLOrkv24BdEKnD6nSq7BT0AcoxVsbDNGAywmozW3zC7gS0a0sIB+pU0OgU371mm5hMz18PffA1bIM1/IKC1edXVuAQv4l0+Pxzc+xnG3RnKG3FlV9QcQ8kAetrFvdiEc9Na3lz93xZmQtHrWgPDyFoA3D1hzq2fXcCrUdpM8wCop9gk+QlByJ1wdCoCgTJgf62muR21KDpTn/6Jas8AxCnZnO4AqJvV2jrV3j0pPHucKRDcFt4dPsQy7IXdhlQJCw4AqocJvOsN+wAAus0LmkyHIpVEvUssEgojTseqXpzWBlUMTPrY7yxd1Rc3E+2SBjHURuIdi+KgNcIOEgvnKljULGeeG7I9IfwjR+XJwNHuKNVqwXVIicPGBs/CI0hADGfT3lQs8u3uMNRtfGY9cm/kMoziHJsc/rswQt7uM81tEXpGncA9mexlxuEbABNNtM7uJlgOTr80n+huAfki2M/cIfnuUhrs7/CJtuVuMuMkabvT7ya+bTWAZcMOZus5EJAuaFBBc1kEOELedXSOFS8wOKDNHJi14a/w4XHG48UwDovMjl66OJaxHW6KHa7xcXdJpCNujoOYjmF/QDXh6Ob8XmK3I5i77LZc7p9kcGdu42kh6WWhx/byHPOMSjqo5+dX5ETjjktvvMKeI7pw47MgDIt754ZSDoUwMP/rfHADgjqEPrVbjkIH7sSOSCbfHb59FplF4gKhXswo7lxa5uyJ7s4aTn9NFrAPBrwYZNb7HiOATu4X5qW55F1n7tojvl33ZN7stWw9TqhTPs8Y5qZYCJPYh7zA6CCCLV1/RvItdMdKEDWiQG9R3w85XrSPQD9W7vh17TDXKYJfUoA2C6Bi8X4842WTDxFI9drK5Fr/6D5t4ek90WOv9HLT0nLYnpvAnFT31gK7ZCUD1fdFqUBVyA8gFPBcaWRT8wUD0/UPFkK5TC29yR4RICdvHTvUiQ0yNnF29uQeTS6Cl/YkBuQTqgb9TNIOjpd5gt6nYBAd6OPX/+9SpI8EiUvuy+yKQeINndB3xtO3cB7VnEBKkO90avR7jmnGXf5nlR8oXj3eHOBZCeQi2f1sgp0a2KFzWQ49uXBTxe7F3g755j4bkW64mlF/KdRm8v51wg92nkgBVlshwvVnuBx2p0D/Ce5Y6/SZE/bC9/IZJFZ4xE+9JOYo5vNR8Wi0c5+YjOj3ph5WkkA7Qf+OrIaoecQj9Q+Gh5+CtiWqW/RzL/0AQnTYpTIAZXx0lj70URQtPbnjd+IfublAVNAP2rLgaeH+n/tftv5Re+j0xM8P5E32hU0AQAkUWEDBEFDR5EmFDhQoYNRRQ5MUDiRIoVK+qzmFHjRo4dPX4EGVKkRQf9TJrsM1LlSpYtXb7MiLElCoc1bd5cSFDGPTGNuFQBGlToUKJFyTQxQhDnUqYOf3Bo6QDmVKpVp+o7aVKmVa5dvVaV6hJLU7JlFeYz0qQLlaJtg05p0oTJPYNKzd69+QOFy61f/f6d2idrvwqADR9GPKAvSxt4HS+1WzAfE8pimljGLIby3Medm5Z4GTbxaNIXBy8unVr1R9EuL3iGjTdy/2zaDenBRL1ad9cKg1PuBh5cYm6VFeDVRp5ceVksEWC2Fh6d72np1UtDZ9nnhMDl3b1/FwFPMW7r5VUKzlrY/Hq/xEdiNFEE/Hz6nbNI/O0SO3v+FLFmda8/AUfa7zyJbqCrPgUXvEk8idTja0AJJSopq/wmxDCkAEOC8Ab5GAQxRIOKMGGiC1kqMMPq/jtpQxVVCwAAGQEoYAAEkJhRCI9SFOlCD0UEUkF4IpoIwpZcfHG3Ck8yMsnqDnBugCEM0HCqJuMLMkvvsiDSxOecXI9FrcAsDwkGbJwyJB5DOnGA7bSEszYbMmpyJSTJLA29k9rEU7cDhpjoBRkLQECjCf8qcEAfRfuogFFH9Yng0UgbhdRRBxxt9NIK0Kjglzg/fYyeTfXBtA9SGUUDUlUjWNUBV/t4ldI1+yxNzH7upJWrCGQMQCIIzLRIH0A7qtPOjcQANVmyQNOo2Pdyja639KDd7YAaLfrTIz5V4rExZb+tyReOthVpVmoPsxXXc7sa4oCMhoiSI2ef5ciXH8DFF6EiWiCWvHV10xOlf0tjYAGKDphx2I7IFWneiX7MF98sTIBg4S8HVi1djCc0V9uPTvA2YlB/wAIkh0FSd2OwBjtZ5ehSbjYkHRIUWcsiamDzYpcT03hn/jq2OCSIawYSnkLV9Nfnw5YUWOkwpwJaIpD/iRaR2YZ1dvqvnrO2LuqNYB6ggw+pps+IG1ZiGGWuAQuYsLWtSxskrynCgmayl/thh5Za3vHt9qjzO9qrXDLhuLuTu8eGLtFOOnCrpN3TceHiZg2mQsY+3DMjcA4Na8mvAvxz3fj2COyK0BgAi3szd+weHSj3iHSOTBc9o7Zlr90r2Dua2yL1ELDBbtaXKsKDiHYf1/PcWdp6edJ6DxamC01QfXicirB6ANw3gt4/50Pz7fvStteo+yItggALzK1PCPuKKUJ+I/JJEv/I0Os/LH6NaPcyIxc8EB77iqCD8gWmcfhT02DMh8ByQU15FdGB4awHj718zYGdY6BImpfB/6/wbyIeHI9HTOCB9dXMCCVYXAEfSC8OfqRtC2wh7y7oknh9hAPwKKGyioCFs4FEfzFZYQxNAyAhfuWH0XsJ2HYAj9WBqgjw4NzVglilIsorfEUcAgCoJJEJzGiLXZTRFuU1wyO5pAYegEcAF/TEEvSQcQdcCQyXt0EGIgAACljAFoVQACo5AFAMSACV+qCwjRzxIjCpYUsiUAMsSHA+bKyBISciRxiCcHm3qyIE+CiRCERJkwbopEQQsMkxTlFtjeuADmyAQ+RkAR422EEUQxgh6ZmyiHTM4CiP1ode2YhQDpCAKBsgRo1I8oNwfKNGaoACG6zSlTi5hxGeaAMPoP+gRIVEpJWQWcVJXhGBuwJAL0e5xQj00gV8dEAvT0DKikggVozSVDzhOU9E0bNUmYLVqCLgAE6lKgL6vKc/9cnPTBEUVqaalKkohSpFTaqfpFpVpVgVqX9S9FGk2tSoEtUHU8FKH43KKKweGilX+RNWl0qUohp6Ule11KUvfWem9OGqmSaKpje1qU1nys2v3a+FCGjA0SoQpRsNIJQ2QkLsDJhEbTJ1mxpcKi15ShIFVvGcW2TAJoU1gKz2kZDFbKpL5mcRY85SPzAZa0XSOsmpxsSnDHQBjmQ0LHBeSzGD+sha++eSsmrvqVB9SV/LasncvbCtVMnAVBL7ksUyFib/jXUJIx6rWJhI9rD+eetlNbvZ2kGuaZwFbWgDh0vRlta0A8PkaVW72nORlrWvha2EmNaPvsbWtrdFV2Zxu1ve6ma2cuxtcIVrJ90O17jHrYphcZtFMYJRi1z04kacS6NCyRUAOvKIdbGLsDCCBJxDcIFEtAsS7j53JN8N7wDGm90cSaS8xNRIeamr3vZ2hLkTea9EJBDdWxbXtHbEox436UeuBnIAg/wIlCTygqN9BAFpmsgevergWoi3Vw+Gb0ckPAACiwQBFVbvhSHs4BEPYMMdJm+UGPwRE9wRCQKecFc5/FUOepa2u/0kJ4k6zKOO0yMvwG6JPVLio15VJLXo/6WQO1Jkdo6EAEnOMEeIHCUjgwTIElHyRnxsVCrzscdN5qBrVatL/IgzqMAUZpQpEoBhIUADePWIm+GsD3ESKiQ+RoCgaCS3YPqywR4uQInkvOc4v5nQFajzNT3CZlEa2q4cAeoWES3KX/Y50kVM7WrBWWdymhOd6mzypieigTNdBLwZEfUHAVVOiVTZIqmWUi/9Q+OMpLPVYAYJAfo86xTODlBo6GWOP0JqktC6IsIGdpptPQBhx1DMpwWqUIma1B4nlSMBeDR+jR1fQEFKlNb+yFErki2PVHsl4j7YtjOSLXO/79rZdq+6KX00c5u7iLOtbRGrLOOtyhjFGkHyu/8S2ZFaOMff8p5IwTUCr48cXCUPGDiWI74RAhh8kxEYgrs5EnCLQDzOpOQ3oAww4Iz3l4i2jWvC8APnuxJ6IwxowMFm9IAEq5yTLO8IA2YEAECVF+EfxDlIdK7y8hLgI/uda5FkZLCPCCHm+LW5lg3N8wexvK7c/C1ytb51qjyb618HO1mrGnayl92tJzd72stu43yr3e2i9frb5X7bTM/d7sGN+931blp8793vt8373wV/2KwP3vCmDfzhFd9C5S7e8YdN/OMl7zy2T97yJm/R5TXPwbpv3vPOi/znRb+zvo/e9J8L/elVT63Cr971Tkv962WfpMbP3vb/iv3tdd9Vn8rv3ve0yv3vhR+dzg/f+BIK/vGVfx1vLt/5YTpNRCcqfepP3/rVx/71tZ997m/f+90H//fFH37yj9/85Uf/+dWffvav3/3th//75R9/+s9/+ikNCAA7" ALT="MyPic">
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can use dummy series. Say the x axis scale is from 0 to 9000. Create 3 series containing 3000, 6000 and 9000 and plot as a filled radar chart. Make sure the series order is from highest to lowest so that they are all visible and set the appropriate area fill for each series. Then add your data setting the area fill to none and a suitable border colour and weight.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,748
Sorry Stuart, I missed the target (pun intended) :(.

I read your post about drawing a target and forgot that in the title you wrote that you want a spider chart.
 

StuLux

Well-known Member
Joined
Sep 14, 2005
Messages
603
Thanks guys

The prize goes to ......Andrew - the plotting of dummy series as filled radar charts gives me what I need.

Gramit - how did you paste your picture of a spider chart on the forum?
 

Forum statistics

Threads
1,081,530
Messages
5,359,349
Members
400,524
Latest member
Excelbat

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top