View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
intersection row and column intersection row and column is offline
external usenet poster
 
Posts: 4
Default XY Scatter question : 2 data for each point (x and y)

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