# How to get corresponding Xvalue for specific Yvalue from XYScatte.

1. ## 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. ## 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

best wishes

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

"azmodeus" <azmodeus@discussions.microsoft.com> wrote in message
news:A4932B10-B3EA-4094-8D8F-25EBF6C8A07F@microsoft.com...
>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. ## 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
>
> best wishes
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "azmodeus" <azmodeus@discussions.microsoft.com> wrote in message
> news:A4932B10-B3EA-4094-8D8F-25EBF6C8A07F@microsoft.com...
> >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. ## 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-

--
Regards,

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

In article <E5A3BEC9-B9A8-460C-AE05-C02B6E98E7CE@microsoft.com>,
Azmodeus@discussions.microsoft.com 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
> >
> > best wishes
> >
> > --
> > Bernard V Liengme
> > www.stfx.ca/people/bliengme
> > remove caps from email
> >
> > "azmodeus" <azmodeus@discussions.microsoft.com> wrote in message
> > news:A4932B10-B3EA-4094-8D8F-25EBF6C8A07F@microsoft.com...
> > >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. ## 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-
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <E5A3BEC9-B9A8-460C-AE05-C02B6E98E7CE@microsoft.com>,
> Azmodeus@discussions.microsoft.com 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
> > >
> > > best wishes
> > >
> > > --
> > > Bernard V Liengme
> > > www.stfx.ca/people/bliengme
> > > remove caps from email
> > >
> > > "azmodeus" <azmodeus@discussions.microsoft.com> wrote in message
> > > news:A4932B10-B3EA-4094-8D8F-25EBF6C8A07F@microsoft.com...
> > > >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. ## 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 <013FC535-6073-4B24-8BE1-9CE4C5212D75@microsoft.com>,
Azmodeus@discussions.microsoft.com says...
> Thanks Tushar, It solved my problem. Thank you very much!
>

{snip}

##### Users Browsing this Thread

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

#### 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