| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
XY Scatter question : 2 data for each point (x and y)
Hi,
I'm not sure I understand - it seems to me you have answered your own question - you should use and XY Scatter chart. Enter X values in one column and your Y values in another column , select the data and choose Insert, Chart. On the first screen choose XY Scatter. -- Thanks, Shane Devenshire "intersection row and column" wrote: 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
XY Scatter question : 2 data for each point (x and y)
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.... "ShaneDevenshire" wrote: Hi, I'm not sure I understand - it seems to me you have answered your own question - you should use and XY Scatter chart. Enter X values in one column and your Y values in another column , select the data and choose Insert, Chart. On the first screen choose XY Scatter. -- Thanks, Shane Devenshire "intersection row and column" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| scatter plot data point labelling question | Charts and Charting in Excel | |||
| Data point labels in a scatter diagram | Charts and Charting in Excel | |||
| Scatter Chart Data Point Highlighting | Charts and Charting in Excel | |||
| Data point labels in XY scatter chart | Charts and Charting in Excel | |||
| scatter plot & label for a data point | Charts and Charting in Excel | |||
Linear Mode
