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.
One Response to “Easily Convert JSON to Excel – Step by Step Tutorial”
Great guide! You mentioned that "Power Query in Excel offers a quick, easy and straightforward way to convert JSON to Excel." This is very true for simple structures. For those dealing with deeply nested JSON that Power Query struggles with, I've found a few tips helpful: 1) Flatten the JSON structure before importing if possible, 2) Use Python for more complex transformations as you suggested.