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.
This used to be a blog about data visualization using MS Excel. I have moved on from adding new articles to it because it is no longer a part of my core professional responsibility. That said, this blog remains a memoir of wonderful times in my life and I hope the charts give you the same joy and inspiration I enjoyed while creating them. Thank you for visiting.