Lorenz Curve plot

**Vasudhas** · 01-30-2009, 09:08 AM

Hi,

I need help in plotting the data in the attached Excel sheet(sheet1).The data n a lorenz curve plot on the right is given(pls scroll right and scroll down a bit as well...).In the data table, the lorenz curve has been drawn from the data taken from column Nos. 3,4 , 6 &7. the diagonal line is called the equality line which can be drawn by giving dummy values to both x and y axis. i want to understand the steps by which the shown curve has been plotted using the given data.(We picked this data and corr diag from one of the study notes) I and my friend tried it using bar graph and then using pivot table to do it. But this graph is not coming up

Would be great if someone can tell me the "steps" to plot the shown graph using the data given.This is required by my Dad who is working on his thesis and I kinda promised him a solution for this. Positive that some gurus can help me thru with this

P.S: Kindly suggest the steps for Excel 2003 version

regards,
Vasudha

**Andy Pope** · 01-30-2009, 09:26 AM

You need to create a xy-scatter chart with 3 series.

your data is laid out such that the Y values come first. so try this.

Select H9:H18 and create an xy-scatter line without markers.
This will create a default set of x values which you can change.

Right click chart and pick Source Data.
Select the series and set the X values to I2:I21

Also add another series and set the x value to L2:L21 with Y values K2:K21

For the final straight line you can enter fixed values in the new series
X: ={0,100}
Y: ={0,100}

format lines and labels as required