Use of Trendlines in Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-2138072%22%20slang%3D%22en-US%22%3EUse%20of%20Trendlines%20in%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2138072%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20the%20first%20time%20I've%20tried%20to%20use%20Trendlines%20in%20charts%20in%20this%20fashion%20and%20it's%20not%20working%20for%20me.%20I%20chart%20a%20two%20column%20cell%20range%20with%20resistance%20on%20the%20x-axis%20and%20temperature%20on%20the%20y-axis.%20I%20draw%20either%20a%204th%20order%20poly%20or%26nbsp%3B%20log%20trendline.%20I%20want%20to%20test%20the%20equation%20so%20I%20display%20the%20trendline%20equation%20on%20the%20chart%20and%20then%20copy%20it%20into%20a%20cell.%20When%20I%20enter%20a%20value%20for%20the%20x-axis%20resistance%20the%20resulting%20temperature%20I%20get%20from%20the%20equation%20is%20nowhere%20near%20the%20trendline%20on%20the%20chart.%20What%20am%20I%20doing%20wrong%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2138072%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

This is the first time I've tried to use Trendlines in charts in this fashion and it's not working for me. I chart a two column cell range with resistance on the x-axis and temperature on the y-axis. I draw either a 4th order poly or  log trendline. I want to test the equation so I display the trendline equation on the chart and then copy it into a cell. When I enter a value for the x-axis resistance the resulting temperature I get from the equation is nowhere near the trendline on the chart. What am I doing wrong here?

1 Reply

@Martin Noyes 

Cancel that. After magnifying the chart and placing horizontal gridlines on it it does appear to provide a y-axis value that is close to the trendline.