Excel Charts<\/strong>, there are so many ways in which you can manipulate them, so that is almost unreal to expect someone to know all the hacks and tricks to it.<\/p>\n\n\n\nIn the example below, we will present one of the useful things that you can do in the chart, and that is to extend a trendline<\/strong>.<\/p>\n\n\n\nExtend a Trendline in Excel<\/h2>\n\n\n\n We will use a linear trendline<\/strong> for our example, although the same approach is used regardless of the trendline type. Our chart will be created from the following table of Xs and Ys<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo create a chart, we will select our data and go to Insert >> Charts >> Recommended Charts<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the window that appears, we will choose the third option<\/strong>, which refers to a Scatter Chart<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOnce we click OK<\/strong>, we will have the same chart created as in the picture above. When we double-click on the trendline in the chart<\/strong> (or right-click<\/strong> on it and choose Format Trendline<\/strong>) we will get the window on the right side where we will see the Trendline Options<\/strong>. In this window, when we scroll down we will see the Forecast option<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nA forecast is set to 0<\/strong> once the chart is created (both for forward and backward<\/strong>). We changed it to 1<\/strong>, and our chart will immediately be changed in a way that we will have our trendline extended for the forecasted figures:<\/p>\n\n\n\n <\/figure>\n\n\n\nIn this particular Chart Design<\/strong>, the forecast will be a little thinner<\/strong>, but we can always change the design. The important thing is that we extend the trendline with the forecast option.<\/p>\n","protected":false},"excerpt":{"rendered":"When dealing with Excel Charts, there are so many ways in which you can manipulate them, so that is almost unreal to expect…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Extend a Trendline in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n