Spreadsheeting Home Page

Lorenz Curves: what they are

Lorenz Curves: the issue of a bonus

This page uses screen shots of the Excel spreadsheet that I developed to plot Figure 2 in the accompanying page to this one.

Enter your basic data as shown here:

Select the data, including the headings:

Select INSERT CHART or click on the Chart Icon … … and choose the XY (Scatter) option.

Click on Next and you should see this:

Click the Series Tab to check that everything is in order, as you see here:

Click Next and enter your chart and exes titles. You can then click on the Legend Tab and move the Legend (I tend to put it at the bottom of my graphs) … or not, it's your choice!

Click Next to choose where in your spreadsheet you want to display your chart: on a sheet by itself (As new sheet) or in a sheet you already have open (As object in:)

Now click Finish and that's it. Congratulations!

Finally, if it just won't work for you and you'd like a copy of the spreadsheet I developed, just let me know and I'll send you a copy. Tell me a bit about yourself while you're at it!

© Duncan Williamson
17 February 9 2002 revised 9 February 2004