+ Reply to Thread
Results 1 to 6 of 6

How to get corresponding Xvalue for specific Yvalue from XYScatte.

  1. #1
    azmodeus
    Guest

    How to get corresponding Xvalue for specific Yvalue from XYScatte.

    I have drawn an XYscatter chart connected with smooth lines. I want to get
    the corresponding value on X axis at a know value of Y (50%) how can I do it?
    Is it possible to show the calculation by perpendicular dropping lines?

  2. #2
    Bernard Liengme
    Guest

    Re: How to get corresponding Xvalue for specific Yvalue from XYScatte.

    You need to find an equation that fits the data. Is it linear or polynomial
    I will give more info based on your answer.

    best wishes

    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "azmodeus" <[email protected]> wrote in message
    news:[email protected]...
    >I have drawn an XYscatter chart connected with smooth lines. I want to get
    > the corresponding value on X axis at a know value of Y (50%) how can I do
    > it?
    > Is it possible to show the calculation by perpendicular dropping lines?




  3. #3
    Azmodeus
    Guest

    Re: How to get corresponding Xvalue for specific Yvalue from XYSca

    It has random values and I can't find any equation related to it.
    The values for X are {0.250 0.315 0.400 0.630 0.800 1.000 1.250 2.000 2.500
    3.150 6.000} and The values for Y are {4.37% 7.98% 13.54% 50.29% 85.86%
    94.39% 96.56% 98.97% 99.54% 99.80% 100.00%} total 11 values in each.
    Thanks alot!


    "Bernard Liengme" wrote:

    > You need to find an equation that fits the data. Is it linear or polynomial
    > I will give more info based on your answer.
    >
    > best wishes
    >
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "azmodeus" <[email protected]> wrote in message
    > news:[email protected]...
    > >I have drawn an XYscatter chart connected with smooth lines. I want to get
    > > the corresponding value on X axis at a know value of Y (50%) how can I do
    > > it?
    > > Is it possible to show the calculation by perpendicular dropping lines?

    >
    >
    >


  4. #4
    Tushar Mehta
    Guest

    Re: How to get corresponding Xvalue for specific Yvalue from XYSca

    Random values? It sure doesn't look like that from a XY Scatter chart.

    Search the google.com archives for Dave Braden's cubic spline code or
    visit xlrotor.com for the bezier curve code. Or consider 'Interactive
    Chart' (http://www.tushar-
    mehta.com/excel/software/interactive_chart_display/index.html), which
    uses stepwise linear interpolation -- and for your data it looks a
    fair-to-good fit. Yet another option is 'Read X and Y value of any
    point on a chart' (http://www.tushar-
    mehta.com/excel/tips/read_chart_value/index.html)

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > It has random values and I can't find any equation related to it.
    > The values for X are {0.250 0.315 0.400 0.630 0.800 1.000 1.250 2.000 2.500
    > 3.150 6.000} and The values for Y are {4.37% 7.98% 13.54% 50.29% 85.86%
    > 94.39% 96.56% 98.97% 99.54% 99.80% 100.00%} total 11 values in each.
    > Thanks alot!
    >
    >
    > "Bernard Liengme" wrote:
    >
    > > You need to find an equation that fits the data. Is it linear or polynomial
    > > I will give more info based on your answer.
    > >
    > > best wishes
    > >
    > > --
    > > Bernard V Liengme
    > > www.stfx.ca/people/bliengme
    > > remove caps from email
    > >
    > > "azmodeus" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >I have drawn an XYscatter chart connected with smooth lines. I want to get
    > > > the corresponding value on X axis at a know value of Y (50%) how can I do
    > > > it?
    > > > Is it possible to show the calculation by perpendicular dropping lines?

    > >
    > >
    > >

    >


  5. #5
    Azmodeus
    Guest

    Re: How to get corresponding Xvalue for specific Yvalue from XYSca

    Thanks Tushar, It solved my problem. Thank you very much!

    "Tushar Mehta" wrote:

    > Random values? It sure doesn't look like that from a XY Scatter chart.
    >
    > Search the google.com archives for Dave Braden's cubic spline code or
    > visit xlrotor.com for the bezier curve code. Or consider 'Interactive
    > Chart' (http://www.tushar-
    > mehta.com/excel/software/interactive_chart_display/index.html), which
    > uses stepwise linear interpolation -- and for your data it looks a
    > fair-to-good fit. Yet another option is 'Read X and Y value of any
    > point on a chart' (http://www.tushar-
    > mehta.com/excel/tips/read_chart_value/index.html)
    >
    > --
    > Regards,
    >
    > Tushar Mehta
    > www.tushar-mehta.com
    > Excel, PowerPoint, and VBA add-ins, tutorials
    > Custom MS Office productivity solutions
    >
    > In article <[email protected]>,
    > [email protected] says...
    > > It has random values and I can't find any equation related to it.
    > > The values for X are {0.250 0.315 0.400 0.630 0.800 1.000 1.250 2.000 2.500
    > > 3.150 6.000} and The values for Y are {4.37% 7.98% 13.54% 50.29% 85.86%
    > > 94.39% 96.56% 98.97% 99.54% 99.80% 100.00%} total 11 values in each.
    > > Thanks alot!
    > >
    > >
    > > "Bernard Liengme" wrote:
    > >
    > > > You need to find an equation that fits the data. Is it linear or polynomial
    > > > I will give more info based on your answer.
    > > >
    > > > best wishes
    > > >
    > > > --
    > > > Bernard V Liengme
    > > > www.stfx.ca/people/bliengme
    > > > remove caps from email
    > > >
    > > > "azmodeus" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >I have drawn an XYscatter chart connected with smooth lines. I want to get
    > > > > the corresponding value on X axis at a know value of Y (50%) how can I do
    > > > > it?
    > > > > Is it possible to show the calculation by perpendicular dropping lines?
    > > >
    > > >
    > > >

    > >

    >


  6. #6
    Tushar Mehta
    Guest

    Re: How to get corresponding Xvalue for specific Yvalue from XYSca

    You are welcome. And, I am curious. It was...

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > Thanks Tushar, It solved my problem. Thank you very much!
    >

    {snip}

+ 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