To be honest, I have no idea what to call this kind of chart.
I was inspired by this useful HTML5 readiness tool
. As you move the mouse over the rays the index ray follows the mouse pointer so you know which category is which. It's pretty cool.
Crafting this project I learned that there are some chart properties that you can access from the Excel 2007 Format Data Series dialog box that cannot be addressed from VBA; and vice versa.
For lines, you can set the Cap Type under Line Style in the regular interface. You have three choices: Square, Round, and Flat. Under Joint Type, you also have three choices: Round, Bevel, and Miter. Nowhere in the VBA object model can these properties be set. I needed to set the index ray to a Cap Type of Flat in VBA and it cannot be done - so it's round. You would think that you could set it beforehand from the interface - and of course you can - but changing the line color from VBA also changes the Cap Type!
While hunting through the expansive forest of the VBA object model for 2007 charts, I found a couple of interesting objects that are not addressable from dialog boxes - and so 99.99% of Excel 2007 users are likely unaware of them. For chart lines (and some other items) you can set them to glow. You can set the color and the radius of the glow. You can also specify SoftEdges, and I used this on the background darkish ring in this chart. Again, these two interesting settings can only be addressed from VBA.
I don't have Excel 2010 yet. I hope this kind of strange oversight is rectified in the new version.
This chart uses a modified version of Jon Peltier's chart events class, and just like my Eurovision 2009 chart
, the interactivity and animation only works when the chart is selected. When you first open the workbook the chart will be selected. But if you click on the worksheet instead of the chart, you will need to click the chart again to reengage the interactivity. Be sure to change the years by clicking on them at the top.
Here's the chart.
If you liked this article, please share it!