|
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? |
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" wrote in message ... 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" wrote in message ... 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 , 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" wrote in message ... 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 , says... Thanks Tushar, It solved my problem. Thank you very much! {snip} |
| All times are GMT +1. The time now is 04:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com