Stacked Bar/Column Chart with Indicator Arrows – Advanced

Last week I wrote a post on how to develop a Stacked Bar/Column Chart with an indicator arrow which you can read here: http://chandoo.org/wp/2016/09/12/stacked-bar-and-indicator-arrow-chart-tutorial/

sba01

This week I have taken that technique and added some high-performance steroids.

I have allowed for three (High, Medium and Low) Indicator arrows, which can be in any order

sba04 sba03 sba02

 

I am not going to go through how to construct it, as it is exactly the same as last weeks post, except that it needs a few helper cells.

sba06

It can be applied to both Column Charts as above or Bar Charts as below:

sba08

The other thing to remember is that you can use any Shape as the indicators.

sba07

Please download the sample file here, pull it apart and see what you think.