How to Make Trend Charts With Excel

1. Create a chart with names and grades. This can be mock information. In cell A1, type 'Names' and in cell B2 type 'Grade'. Enter the names and grades for 10 students.
2. Click the Insert tab. Click the down arrow under the Column option. Select the first option under the 2-D Column row. A chart will appear.
3. Right-click on one of the bars in the graph. Go to Add Trendline.
4. Select the Linear radio button, then click 'Close.' A trendline has been added to the chart for a trend chart.