geepeetee wrote:
Hi

Thanks, that worked a treat. Just one last thing, we need a "line of best
fit" which a straight line which goes through as many points a possible.

I have drawn this on and its fine but wondered if there is a way of letting
the software do it.

Cheers
Gary

-------------------------

Right click on the line on your chart. A menu will open which includes
"Add Trendline". You can follow your nose through the steps then to get
a curve fit line of various types to show up. It defaults to a straight
line. You can also ask it to display on the chart the parameters it
found for the line it chose -- slope and offset.

Bill