Quite recently, Jon Peltier suggested an interesting way of preparing Arrow Charts to show how a set of values changes between one point in time and another. The twist came in the manner of inserting shapes, in the form of suitable arrows, to replace the visible stacked bars in the chart. Inspired, I took the same data table and created my version of arrow charts with error bars. The chart on the left is a Line chart, while the one to the right is a combination of Stacked bar and XY Charts. Since the budget values are represented in the numerical axes in both charts, I chose to include labels that would suggest the percentage change in budget for each division.
My last project involved using a multitude of regions for drawing analysis, parallels and comparison. Not wanting to use yet another Choropleth graph, I decided to look up alternatives that were easier to create and preferably required no VBA. Soon I stumbled upon "The Dorling Cartogram", defined in the UCSB site as, "This type of cartogram was named after its inventor, Danny Dorling of the University of Leeds. A Dorling cartogram maintains neither shape, topology nor object centroids, though it has proven to be a very effective cartogram method. To create a Dorling cartogram, instead of enlarging or shrinking the objects themselves, the cartographer will replace the objects with a uniform shape, usually a circle, of the appropriate size." I had the data for Obesity in the United States handy, so I decided to give it a try before using it in my project. I opted to use Bubble charts because data points within a series may need to be of varied shapes based on