'Trendline' in chart "curves" in the incorrect direction

How can I fix this? It also shows the wrong equation when I display the trendline equation.

This question has been partly answered over on this forum thread.