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
Bookmarks