Hello!
In my Line+Bar_GDP+HDI tab, I am trying to create a bar chart with a line chart over it. The bar chart being GDP Per Capita and the line chart being HDI Value, for years 1990-2015, for a filtered country (US in this case).
But when I try create the line chart, it seems like I'm getting more of a total sum of HDI values, not the HDI values for the US. How can this be fixed?
3 answers
I have restructured the data source to do a union of the 3 sheets, pivot the data, create a couple of calculations and then used it to build out the chart as needed.
Hope this helps. You can check out the updated workbook attached.
