Hello, i am trying to add a trendline to graph which has 4 points and is
supposed to be producing a straight line (but does not always), so due to
these slight variations, the formula that i get from the trendline is not
always correct. i was wondering if there is a way to get a straight trendline
no matter the values are slightly a bit off, by just ignoring the ones which
dont fall under the "straight line category" ?? for instance, if the 3rd
value is slightly off, then ignoring just the 3rd??

if there is a way to do it through vba, and if you could show me a very
small example of the syntax or the code, or if it could be done in excel
itself, would be a great help as i am hoping to get my course work right..lol