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??
Bookmarks