A curve fit with Solver would be possible if you have an idea what function
you wish to fit the data to.
Contact me privately if you wish to explore this idea.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Becky Hutchinson" wrote in
message ...
they're not linear or polynomial. some are like exponential but upside
down
(yet not logarithmic, dunno what they're called). some are like the shape
of
a black body curve if you ever did physics alevel. they're weird shapes
that
can't be mapped onto a 'normal' function. what i really need to know is
how
to get excel to read x values for a given y value

"Bernard Liengme" wrote:

You did not tell if the fit is linear or not
You can use LINEST to fit to linear, polynomial, log etc
See www.stfx.ca/people/bliengme/ExcelTips and
www.tushar-mehta.com

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

"Becky Hutchinson" <Becky wrote in
message ...
i have excel 2003 and am trying to create graphs for an electronics lab
write
up. I have entered information into a table and created scatter
diagrams
etc
but i want to put on a line of best fit. The trendline function does
not
work
well enough for what i want, and i remember there being an option for a
line
of best fit on an older version of the program. is there a way to do
it?
The
reason i am asking is because i want to read off values from my graph,
i.e.
on a voltage vs frequency graph i want to know what the frequency would
theoretically be at 0.707 volts. if i can not create a best fit line,
is
there a way to do this??