+ Reply to Thread
Results 1 to 7 of 7

Plotting two Lorenz curves from data sets with different number of positions

  1. #1
    Registered User
    Join Date
    11-23-2014
    Location
    Essex
    MS-Off Ver
    2010
    Posts
    4

    Post Plotting two Lorenz curves from data sets with different number of positions

    Hi everyone!
    I am hoping someone will be able to help me to figure out how to adjust the graph with two Lorenz curves. So the problem is that one data set I am using has 11 positions and another has 12. When I am plotting two Lorenz curves they are not adjusted (in case it's hard to understand check the attached picture). I want them to be uniform in regard to the line of the best fit. What should I do?

    Best,
    Liv
    Lorenz.JPG

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Plotting two Lorenz curves from data sets with different number of positions

    you wanted smth like that?

  3. #3
    Registered User
    Join Date
    11-23-2014
    Location
    Essex
    MS-Off Ver
    2010
    Posts
    4

    Re: Plotting two Lorenz curves from data sets with different number of positions

    Yes! That's exactly what I am looking for! Could you please write what I have to do?

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Plotting two Lorenz curves from data sets with different number of positions

    unfortunately i don't know english axcel menu but i'll try
    1 insert a dot graph (tab all graphs 8-th from the top a 2-nd from the left)
    2 add one more row

  5. #5
    Registered User
    Join Date
    11-23-2014
    Location
    Essex
    MS-Off Ver
    2010
    Posts
    4

    Re: Plotting two Lorenz curves from data sets with different number of positions

    I attached the file with my numbers, I still don't know how to do it even following your steps. Can you take a look?
    I am sorry that I bother you with things like this :-/qqq2.xlsx

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Plotting two Lorenz curves from data sets with different number of positions

    not at all
    ____________________

  7. #7
    Registered User
    Join Date
    11-23-2014
    Location
    Essex
    MS-Off Ver
    2010
    Posts
    4

    Re: Plotting two Lorenz curves from data sets with different number of positions

    Thank you! You cannot even imagine how grateful I am for helping me out, now I understand! Thank you again for your time :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Plotting a Lorenz Curve (excel 2010)
    By daisy_pm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2013, 07:15 PM
  2. Plotting curves showing less points than actually used
    By simaosig in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-30-2013, 08:36 AM
  3. plotting a lorenz curves
    By jijjiio in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-10-2013, 11:09 PM
  4. Plotting a Lorenz Curve
    By abeattie3 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-07-2012, 11:48 AM
  5. Transposing vertical data sets to horizontal positions
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2011, 01:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1