+ Reply to Thread
Results 1 to 2 of 2

Can I obtain x values from y values on an Excel chart?

Hybrid View

  1. #1
    Helen
    Guest

    Can I obtain x values from y values on an Excel chart?

    I've constructed an exponential curve, is there a function whereby I can
    enter new y values to obtain the corresponding x values, instead of having to
    print it off and read off manually?

    Many thanks from a novice

    -Helen Moore

  2. #2
    Bernard Liengme
    Guest

    Re: Can I obtain x values from y values on an Excel chart?

    if Y=A*Exp(BX); then Ln(Y) - Ln(A) = BX or X= (Ln(Y) -Ln(A))/B

    Also remember you can use LOGEST or LINEST to extract the trendline
    coefficients into cells rather than copying them form equation on chart; see
    http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
    http://www.stfx.ca/people/bliengme/E...Polynomial.htm
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Helen" <Helen@discussions.microsoft.com> wrote in message
    news:6779EAB3-CACA-4377-B2D4-75F4C5B2421E@microsoft.com...
    > I've constructed an exponential curve, is there a function whereby I can
    > enter new y values to obtain the corresponding x values, instead of having
    > to
    > print it off and read off manually?
    >
    > Many thanks from a novice
    >
    > -Helen Moore




+ 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