fbpx
Search
Close this search box.

Stacked Bar/Column Chart with Indicator Arrows – Advanced

Share

Facebook
Twitter
LinkedIn

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.

 

 

 

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

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

  1. PRAVIN BHAISWAR says:

    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

    • Hui... says:

      @Juanbriones
      Go through the steps in making a Horizontal one first
      http://chandoo.org/wp/2016/09/12/stacked-bar-and-indicator-arrow-chart-tutorial/
      You need to understand this process first

      Then look at the helper cells in the advanced chart, put the value 4 in all the Arrow Value cells which are currently 0
      You will see there are 12 series in Total, some of which are 0 and hence don't display arrows
      Otherwise it is exactly the same as the simple version

      • Imtiyaz Khan says:

        Hello members.how some spacified excel data not fixed whether all along or some break/s into separate each or multi excel personal ledger account files also exist there as an auto out reflection from main master excel sheet without efforts of copy paste posting from main.Kindly go on step by step into excel all Era training.The pattern is good.Thanks. Imtiyaz Khan

  5. Blaz says:

    Thanks Hui,

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

    Regards,

  6. Vandan Dave says:

    Please explain this formula

    ="We are "&IF(INT(K21)=INT(K18),"on",TEXT(ABS(K21-K18),"0")&" days "&IF(K21>K18,"behind ","ahead of"))&" plan."

Leave a Reply