Using Excel's TREND function will help you identify ... and the trendline on the x-axis, but we want the trend data to show as a line. To amend this, click anywhere on the chart, and select ...