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.
2 Responses to “Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org”
How did you arrive or formula when you ask me who made more sales Jackie or Jamie?? I could not figure the formula out yet??
@Frank
You need to sum up the sales for Jackie and compare them to the sales of Jamie over the same period.
The practical parts depends on how and what data you have and how it is arranged.
But it will either involve a Sum, Sumif, Sumifs or Sumproduct to accummulate the sales for each within a specified date range.