Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
line of best fit/reading values from graphs
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Producing line and bar graphs on same axis | Charts and Charting in Excel | |||
Line Graphs - How do I plot N/As? | Charts and Charting in Excel | |||
Removing 0 or none 0 values from graphs | Charts and Charting in Excel | |||
graphs showing unwanted zero values | Excel Discussion (Misc queries) | |||
search after values | Excel Discussion (Misc queries) |