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/
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
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.
It can be applied to both Column Charts as above or Bar Charts as below:
The other thing to remember is that you can use any Shape as the indicators.
Please download the sample file here, pull it apart and see what you think.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Formula Forensics No. 041 – Convert a Roman Numeral to a Number||Visualizing target vs. actual progress – Biker on a hill chart|