If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting Excel chart series from vb6 | Jim | Charts and Charting | 7 | January 27th, 2006 09:41 AM |
How do I eliminate duplicate values on y axis of an Excel chart? | Paul | Charts and Charting | 1 | March 24th, 2005 04:26 AM |
Transparent Excel chart backgrounds | Peggy | Charts and Charting | 1 | September 5th, 2004 04:41 AM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Is it possible to plot 3 surfaces in a Pivot Chart? (Repost) | Alison | Charts and Charting | 5 | October 21st, 2003 11:00 PM |