Add a linear trendline to a graph in SQL Server Reporting Services

I have a chart in SQL Server Reporting Services (SSRS), based upon data from a SQL Server table. I want to add a linear trendline to this chart, just like in Excel. In this tip we cover how this can be done.