Create a chart from start to finish Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline. Create a chart Select data for the chart. Data for Chart Select Insert > Recommended Charts. Recommended Charts Select a chart on the Recommended Charts tab, to preview the chart. Recommended Charty Select a chart, then click OK. Finish Chart Add a trendline Select a chart. Select a Chart Select Chart Design > Add Chart Element. Chart Element Select Trendline and then select the type of trendline you want, such as Linear, Exponential, Linear Forecast, or Moving Average. Trendline