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?
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?
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" <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?
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" <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?
>
>
>
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 <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
> > I will give more info based on your answer.
> >
> > 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?
> >
> >
> >
>
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 <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
> > > I will give more info based on your answer.
> > >
> > > 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?
> > >
> > >
> > >
> >
>
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}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks