While trying to create a graph with trendline to predict what a thermistor reading for a Prius’s radiator/engine temperature would be at certain temperatures I started battling MSFT’s Excel.
I created a chart with the known data collected about the voltage at the thermistor for a list of temperatures. I wanted a trendline to show the calculation so that I could use it to calculate the resistance of the thermistor at those temperatures. However, after creating a chart and looking at the trendline formula’s calculation of known data, something was completely screwed up.
After some Google searches there was a link to Microsoft’s Help and Support website that indicated that “the trendline formula should only be used when your chart is an XY Scatter chart.” Great. Well, at least I didn’t waste too much time on it and it was an easy fix. However, why didn’t MSFT’s Excel team not grey out the trendline option for non-scatter charts?!
Leave a Reply