{"id":261,"date":"2018-06-27T16:34:20","date_gmt":"2018-06-27T16:34:20","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=261"},"modified":"2024-03-30T10:48:33","modified_gmt":"2024-03-30T10:48:33","slug":"trendlines","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/trendlines\/","title":{"rendered":"Trendlines in Excel"},"content":{"rendered":"\n
One of the easiest methods for guessing a general trend in your data is to add a trendline to a chart. The Trendline is a bit similar to a line in a line chart, but it doesn’t connect each data point precisely as a line chart does.<\/p>\n\n\n\n
A trendline represents all the data. This means that minor exceptions or statistical errors won\u2019t distract Excel when it comes to finding the right formula. In some cases, you can also use the trendline to forecast future data.<\/p>\n\n\n\n
The trendline can be added to 2-D charts, such as Area, Bar, Column, Line, Stock, X Y (Scatter) and Bubble. You can\u2019t add a trendline to 3-D, Radar, Pie, Area or Doughnut charts.<\/p>\n\n\n\n
After you create a chart<\/a>, right-click on the data series and choose Add<\/strong> trendline\u2026<\/strong>. A new menu will appear to the left of the chart.<\/p>\n\n\n\n