Stacked Bar/Column Chart with Indicator Arrows – Advanced

Posted on September 15th, 2016 in Charts and Graphs , Excel Howtos , Huis , Posts by Hui - 11 comments

Last week I wrote a post on how to develop a Stacked Bar/Column Chart with an indicator arrow which you can read here:


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.


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.




Written by Hui...
Tags: , , , , , , ,
Home: Main Page
? Doubt: Ask an Excel Question

11 Responses to “Stacked Bar/Column Chart with Indicator Arrows – Advanced”


    Amazing Sir! sir still i have problem of that arrow...........that does not work that it works in the sheet you made.

  2. GraH says:

    I'm just wondering if you are not the one on steroids lately, Chandoo (comes close to can do, right?). Is this due to New Zealand's air?
    Anyway this is a very nice alternative to thermo-charts.

    You truly are an inspiration! Thank your that.

    • Chandoo says:

      Thank you. But the credit goes to Hui (who may have dug up some strange steroids during a recent mining expedition) as he is the one who wrote this post (and the FF).

      • GraH says:

        Hui rules! But nevertheless, the creativity on this blog and the contribution of the bloggers are inspiring. And really enabling people to be aweSUM in XL, like you say.
        I followed a training on Excel Dashboards in 2015 and your site was highly recommended by our cool trainer.
        I became aware that XL can-do much more. Ingredients are a little imagination, dare to experiment and knowledge on how to combine techniques/functions.
        In short within 2 weeks I will give a 1 hour XL awareness training in my company during open training week. I just sent a teaser with stuff I found here and on other XL-guru's sites to my HR department. Within the next 5 minutes my proposition was approved. The reply was "Excellent idea!"
        And the funny thing is that I found an XL soul-mate only a few seats away. Now we make each other crazy with challenges and/or things we learn about XL. The very first thing we made for a manager was a biker (representing his team) climbing a mounting (of work) towards the finish (the volume to reach at end of day). Depending on current status, different motivational talk appears in the title. The manager could not believe we just made a simple chart.

        • Chandoo says:

          Very happy to hear that. Congratulations and all the best for your upcoming training. I am going to steal biker vs. mountain chart idea for a future blog post shamelessly 🙂 I am a biker and can't help but appreciating a wonderful idea like this.

  3. indzara says:

    I am sure this will inspire many uses in dashboards everywhere. Thanks for sharing.

  4. juanbriones says:

    excellent post, but I would appreciate if you could explain the horizontal same graph but multiple

  5. Blaz says:

    Thanks Hui,

    I got similar question 2 years ago and you already helped me then!
    Glad to see this tutorial.


Leave a Reply