Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Zero values in a log chart | Charts and Charting in Excel | |||
how can I limit my chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel |