Two most commonly asked or searched queries when it comes to charting are,
- How to combine two chart types in one chart, like a line chart combined with bar chart?
- How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?
Excel combination charts are a great way to combine two chart types in to one.
Using data series options you can plot a particular series on secondary axis.
In this quick video tutorial you can learn how to make a combination chart and add secondary axis in less than 15 seconds.
Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial
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.