when in need of creating trend lines - as this is quite informative of the approach, and helps with the understanding. it will also help with adding trendlines to combo charts on certain axis.
hopefully this helps and will also give you the calcs required to achieve the trendlines in your charts
