+ Reply to Thread
Results 1 to 11 of 11

Graphfic type on Excel

  1. #1
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Graphfic type on Excel

    http://img30.imageshack.us/img30/5508/semttulopv.jpg

    I've been trying for some time to reproduce this type of graphic on Excel with no success. The only thing I know is that is a scatter plot, but that trendline and the %error lines are beyond my understanding. Would someone please show me how can I do it...

    Regards.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Graphfic type on Excel

    You'll need aditional columns for each line:

    Book1.xlsx

  3. #3
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Graphfic type on Excel

    Quote Originally Posted by zbor View Post
    You'll need aditional columns for each line:

    Attachment 52908
    Thank you, that's a good idea. But if you notice the graphic I showed up there, the trendline and the "error lines" are well fit to the graphic.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Graphfic type on Excel

    You didn't post any data, you posted a picture. Zbor used random data and showed a trendline and the two additional (+/-25%) lines.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Graphfic type on Excel

    Quote Originally Posted by shg View Post
    You didn't post any data, you posted a picture. Zbor used random data and showed a trendline and the two additional (+/-25%) lines.
    Yes, I showed a picture with a graphic in it. But what's your point?

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Graphfic type on Excel

    You asked how to do something, Zbor showed you how. I guess I'm wondering what question remains unanswered.

  7. #7
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Graphfic type on Excel

    Quote Originally Posted by shg View Post
    You asked how to do something, Zbor showed you how. I guess I'm wondering what question remains unanswered.
    But it wasn't showed exactly. In the picture, the trendline and the +-25% error lines adjust completely to the size of the graphic's square. I hope I've explained it right...

    Nevertheless, my thanks again to Zbor, obviously.

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Graphfic type on Excel

    Just adjust the scales.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Graphfic type on Excel

    Quote Originally Posted by shg View Post
    Just adjust the scales.
    Ok

    Thank you very much and sorry for my ignorance.

    Regards.

  10. #10
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Graphfic type on Excel

    Quote Originally Posted by Fernus View Post
    But it wasn't showed exactly. In the picture, the trendline and the +-25% error lines adjust completely to the size of the graphic's square. I hope I've explained it right...

    Nevertheless, my thanks again to Zbor, obviously.
    It's not clear from picture: is +-25% static value or dynamic? Does all points need to be included between +- lines? 90%? 75% Does they need to be equal +-25% or can be different +20%, -30%?

    There is lot of things that your explanation don't cover.

    If you want to get what you need you need to explain as better as possible.

    Also, better way is to upload excel workbook (without sensitive data) instead of picture. Now we need to guess what data's could be used and spend more time to do data then to provide solution from it. Someone will help you to get your answer - make sure you help him to come to answer easier

  11. #11
    Registered User
    Join Date
    09-12-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Graphfic type on Excel

    You are right. But that was almost all the information I got too

    95% of the points must be included between those 2 error lines. And 25% is not static, it can change depending on those 95%.

    Thank you for your help once again.
    Last edited by shg; 09-12-2009 at 02:10 PM. Reason: deleted spurious quote

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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