So pretty much I want to recreate the first chart and my current worksheet looks like the second one. I tried adding the GDP per capita to row and switched Pop.Per to percentage of total but the chart remained the same. How could I recreate the first chart? Thank you!
1 answer
@Keqin Liu
The x-axis scale on the original looks to be cumulative % of total - it goes from 1-100%.ie
Country A 1% plotted at 1%
Country B 1% plotted at 2% (1+1)
Country C 3% plotted at 5% (1+1+3)
so you'll at least need to adjust the variable on your Columns shelf so it is calculating this way.
You'll need to post a packaged workbook if you need further help.
Regards
Donna
