XY Scatter question : 2 data for each point (x and y)

  • Thread starter intersection row and column
  • Start date
I

intersection row and column

I would like to create the following chart.
Let say I have for each region (region1, region2 etc...) the share in the
total population and the share in the total income.
ex. Region 1 : 5% of population 15% of income (rich)
Region 2 : 20% of population 5% of income (poor) etc ....
I would like the % of population as the x-axis and the % of income as the
y-axis.
Each region will be a point in the diagram.
The diagram has two parts : poor and rich with different colors
thx
 
I

intersection row and column

the problem I have is that I don't see the names of the regions as data labels.
also I would like to add colors to define the zones "Poor" and "Rich" and an
arrow to cut the graph in 2....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top