Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

How Do I Create Lorenz Curve In Excel????

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version. Please
help, i would need it urgently!


View Answers     

Similar Excel Tutorials

Create a Line Chart with a Macro in Excel
Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs ...
Create a Column Chart with a Macro in Excel
This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a ...
Create a Bar Chart With a Macro in Excel
Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and ...
Quickly Create a Huge List of Numbers in Excel
Quickly create a large list of numbers in Excel using the Fill Command.  This will save you time and allow you to ...

Helpful Excel Macros

Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the

Similar Topics


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


I am trying to make a quintile distribution of only 16 data points. The information is 16 countries and their per capita income. I have them sorted highest to lowest but I'm having trouble making the quintile distribution. After that I want to make a Lorenz curve with the data. Is there an easy way to do this in excel?


Hey all,

I am trying to plot the Lorenz curve.

X axis is labelled as "Number of Firms"

Y axis is labelled as "Cumulative size of firms"

Here are the datas:

Firm 1: 100
Firm 2: 200
Firm 3: 300
Firm 4: 400
Firm 5: 500
Firm 6: 600
Firm 7: 700

Could you also show all the steps of plotting the graph in details please?


Can you create the bell curve for a z-score in excel 2003? I don't see it as an option in the chart wizard.



Hi I have a detailed listing of health care claims (by social security number) for an organization. I want to create a bell curve (statistic curve) that will show the mean (average health care claim amount) and the standard deviations that create the curve. Does anyone know how to create this bell curve.

Thanks a lot,

Is there a way to make sure that a text box moves with a curve on a chart? For example, I have a text box on the chart that is a label for a given curve. But if I modify the curve, the text box will no longer point it properly. Is there a way to create an association between the two?

Ok, I may be doing something really dumb, but I can't figure out how to create a chart that plots a curve when I have the (x,y) position for each line on the curve. Excel tries to create the X-axis for me based on a linear scale of it's own. Can anyone help me?

X Y 0 175 42 160 82 140 119 120 144 100 168 80 186 60 198 40 207 20 210 0



Hi all,

Newbie to this forum, but need some excel help. I have collected a bunch of data from an object as it heats up. The curve is very similar to a capacitor charging current curve. In my case, manually trying to approximate this curve, I come up with a formula of y= (rise)*(1-exp(-time))+ambient. Is there a way in excel to fit a curve like this or do I need an aftermarket solution? I need something that will use the data points and perform calculations to determine the curve.



Hello Everyone,

I am having hard time to create the bell curve. I have sorted the data (please see the attached file) according to the ditribution (only the green marked data) and I believe I will have to use different formulas to create the column graph and the curve.

I would appreciate it a lot if someone could take a look at this an advise, how to do it. I have already spend couple of hours researching how to do this but it seems to be quiet complex. Is there an easy way to create that type of chart?


If I have a limited number of data points and create a graph with the data (e.g., bell curve, normal distribution, etc.), is there something in Excel that will return all of the data points based on the curve?

For example, if I have 6 monthly data points (e.g., 5, 10, 30, 12, 7, 2) over a period of 12 months and I create a line curve, is there a function that will return all the data points for the remaining months? Also, if I smoothed the curve or did a trendline, I would get different data...


I have created a scatter graph with a regression curve to fit. The y axis data ranges from 0 to 1. How would I, for example, find the x value that corresponds to the y value of 0.5 according to the regression curve (it is a curve, not a straight line)?

In Excel, I am drawing normal distribution charts (your typical
bell-shaped curve) using a column of x values and a column of y values,
and selecting x-y chart selection with smoothed line. I need to shade a
portion of the area under the chart (typically from one x value to the
other). Is there some way in Excel's tools to generate a pattern fill
under the curve, between specified x limits? Now, I'm just using
Excel's drawing tool , Autoshapes, Freeform line, and trying to create
an area that just exactly fits under the curve, but it's difficult to
get all the points to line up under the curve correctly.
I can, of course, shade any closed area made with the drawing
tool, but how to shade part of the area under the normal curve?



I can't seem to find a way of plotting a simple normal distribution curve from a basic set of data. I've created a histogram but playing through the chart options in excel can't find a normal distribution curve. Probably have to add more to the frequencies (SD, Mean etc) which is fine, but can't seem to plot nicely in graphical format

Attached example.

Help is always appreciate as ever.



My boss asked me to create belt curve chart. I am a bit confused either my types data can be used to build belt curve which known as Normal distribution

Can anyone help me?

SCORE RANGE ------------2013 2014

< 3.0 -----------------------150 115
≥ 3 and ≤ 3.5--------------220 280
≥ 3.5 and ≤ 4.0-----------150 210
> 4.0 -----------------------30 60

Help! I have created a bell curve that shows me payment distribution for our sales force compensation. The bell curve works beautifully, however, I would also like to show in this same chart the budgeted average as well as the actual average. I am currently using the rectangle shape in the drawing toolbar to manually input the bars that represent these two data points. I was wondering if there is any way to have excel automatically chart these along with my bell curve.

I have an example that I can send if that helps.


I am trying to create a bell curve graff, firstly to reflect the standard IQ bell curve but then to overlay it using results captured from an IQ study I am conducting. Can anybody help?

How do I find the equation of given data sets and their curve? How to fit the curve in excel 2007?

a B
0.0625 0.179
0.1250 0.484
0.1875 0.626
0.2500 0.735
0.3125 0.802
0.3750 0.838
0.4375 0.882
0.5000 0.907
0.5625 0.938
0.6250 0.963
0.6875 0.977
0.7500 0.999
0.8125 1.022
0.8750 1.041
0.9375 1.053
1.0000 1.066

I have a spreadsheet with 53 rows, representing referrals. We track how long each referral took to resolve. It ranges from 30 minutes to an occasional high of 40 hours or more. I got my average times, median time, and Standard Deviation. I would like to display this as a bell curve so hat I can show the distribution. How do I create a bell curve chart? thanks

I use chromotography(GPC) in my research. This gives bell shaped curve. To compare two cuvres, I need area under the curve. Can any one teach me the way of calculating area under the curve in excel worksheet?(The curve will be in the shape of "Normal distriubution" shape).

Please help


Please see the attached two curves which i want to transfer to excel to automate my
calculations, i made a try in the attached workbook and i need your advice and comments

for the first curve
having t,x i got y
now, is what i have done is true and accurate (using the linear equation) or there a best fit polynomial or other way to do that
I tried LINEST on the rows A3 to A8 if i complete to A33 will it differ or be more accurate
if i have t=12 (or any value between 0,30 which have no exact values on the attached curve) and x =14.5 for example how can i interpolate to find y

with the same x i got y in the curve in the second sheet
is my polynomial is accurate , is there a better way
thanks in advance

can any one help me with customising a bell curve using excel. i already made a bell curve using sample data from microsofts help articles but i do not know how to shade/fill color inside the curve. is it actually possible using excel?

I have a tab/worksheet with several named ranges

The named ranges are defined in this format:
Insert>Name>Define "plot_time"

=OFFSET('Curve Fitter (TC#116)'!$C$13,0,0,COUNTA('Curve Fitter (TC#116)'!$D:$D)-1)

Then these names are used to plot the data in a Line Chart:

Series1>XValues = ='Curve Fitter (TC#116)'!plot_time

This works fine except I need to copy another version of the entire worksheet. Now the new sheet has a new name of course. So my hard-coded links are broken. I need something like the equivalent VBA ThisWorkbook, which would be dynamically updated to reference ThisSheet containing the current chart.

I have problem how to draw a curve onto a polar chart that is based on degree
and its values.

Also after the curve is plotted, then I like to extract the curve equation.


I want to create a bell chart in excel. I have already created the frequency chart and have the bin values. However the bell chart is not working. I have sample data from 1 to 50 where I want to use the original data, and also the issue is my standard deviation, lower limit, upper limit and the mean changes based on values entered.

I have attached the spreadsheet for details

Value is inputed in Cell F9, F10, F11 and sample data is entered in column E13 to E62. The standard deviation, mean value are calculated and stored in N16 and N14 column respectively. Also I want to add a line for upper and lower limit that can change based on the input in F10 and F11.

Can someone help me to create a bell curve and also a normal curve on the same bell curve chart so one can compare the results.

I would sincerely appreciate the help

I have discovered how to create a normal distribution (Bell) curve on my excell spreadsheet. The instructions on the net all seem the same, and the curve always covers the same width 1 to 8 or 9. I am trying to produce a curve to lok at a number of ratings the lowest is 0 and the highest 5 How do I amend the width of the bell. I belive it is something to do with the standard deviation number which is generated and used. But now I'm lost