{"id":3961,"date":"2020-06-04T17:30:38","date_gmt":"2020-06-04T15:30:38","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3961"},"modified":"2024-05-07T15:07:10","modified_gmt":"2024-05-07T13:07:10","slug":"add-trendlines-excel-charts","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-trendlines-excel-charts\/","title":{"rendered":"How to add Trendline in Excel Charts"},"content":{"rendered":"<p>With <strong>Excel Charts,\u00a0<\/strong>it is very easy to create <strong>Trendlines\u00a0<\/strong>for your data. \u00a0<strong>Trendlines\u00a0<\/strong>show which direction the trend of your data is going, and gives you the trajectory as well.<\/p>\n<p>In this tutorial, you will cover all of these sub-topics in details:<\/p>\n<ul>\n<li><a href=\"#how-to-add-trendline-in-excel\">How to add trendline in Excel<\/a><\/li>\n<li><a href=\"#different-types-of-trendline\">Different types of trendline<\/a><\/li>\n<li><a href=\"#format-the-trendline\">Format the Trendline<\/a><\/li>\n<li><a href=\"#use-trendline-to-forecast-future-data\">Use trendline to\u00a0forecast future data<\/a><\/li>\n<li><a href=\"#add-multiple-trendline-to-same-chart\">Add multiple trendline to same chart<\/a><\/li>\n<li><a href=\"#how-to-remove-trendline-in-excel\">How to remove trendline in Excel<\/a><\/li>\n<\/ul>\n<h3><a id=\"how-to-add-trendline-in-excel\"><\/a>How to add Trendline in Excel<\/h3>\n<p>*** Watch our video and step by step guide below on Trend Chart in Excel with a free downloadable workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QjDvcZZ5QJY?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/QjDvcZZ5QJY\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube <\/a><\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<p>In this example, you will learn how to insert a trendline in Excel using a Line Chart.<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/How-to-add-trendline.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/How-to-add-trendline.xlsx\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-add-trendline.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<div id=\"om-frkfeyqnk6w6ywc1jppy-holder\"><\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span>Highlight your table of data, including the column headings:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-3964\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-01.png\" alt=\"How to add Trendline in Excel Charts\" width=\"205\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-01.png 205w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-01-157x300.png 157w\" sizes=\"(max-width: 205px) 100vw, 205px\" \/><\/a><\/p>\n<p>Go to <em><strong>Insert &gt; Recommended Charts (Excel 2013 &amp; 2016)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-3965\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-02.png\" alt=\"How to add Trendline in Excel Charts\" width=\"451\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-02.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-02-300x89.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>Go to <em><strong>Insert &gt; Line &gt; 2-D Line\u00a0(Excel 2010)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-11-04_17-25-48.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-5149\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-11-04_17-25-48.jpg\" alt=\"How to add Trendline in Excel Charts\" width=\"360\" height=\"179\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-11-04_17-25-48.jpg 360w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-11-04_17-25-48-300x149.jpg 300w\" sizes=\"(max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select <em><strong>All Charts &gt; Line\u00a0&gt; OK\u00a0(Excel 2013 &amp; 2016)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-3966\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-03.png\" alt=\"How to add Trendline in Excel Charts\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-03.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-03-300x284.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Right-click on the line of your\u00a0<strong>Line Chart<\/strong> and Select\u00a0<strong>Add Trendline<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-3967\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-04.png\" alt=\"How to add Trendline in Excel Charts\" width=\"611\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-04.png 611w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-04-300x177.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0Ensure\u00a0<strong>Linear<\/strong> is selected and close the\u00a0<strong>Format Trendline Window<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-3968\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-05.png\" alt=\"How to add Trendline in Excel Charts\" width=\"341\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-05.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-05-205x300.png 205w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>Now you have your <strong>Trendline\u00a0<\/strong>in your chart, and you can predict where the trajectory is going in the succeeding periods:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone wp-image-3969 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png\" alt=\"How to add Trendline in Excel Charts\" width=\"582\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png 582w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06-300x180.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/a><\/p>\n<\/div>\n<\/div>\n<div>\n<div>\n<h3><a id=\"different-types-of-trendline\"><\/a>Different types of Trendline<\/h3>\n<p>There are different types of trendlines available to be added to the Excel Charts:<\/p>\n<ul>\n<li><strong>Linear &#8211;<\/strong> It is a straight line that shows the increase\/decrease in the value of data over time at a steady rate.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17901\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png\" alt=\"How to add Trendline in Excel Charts\" width=\"602\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png 602w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192-300x186.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/li>\n<li><strong>Exponential &#8211;<\/strong> It shows the increase\/decrease in the value of data at an increasingly higher rate. It is usually more curved on one side.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/c122ae16a4459711c028dc0469e7198c.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18135\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/c122ae16a4459711c028dc0469e7198c.png\" alt=\"How to add Trendline in Excel Charts\" width=\"611\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/c122ae16a4459711c028dc0469e7198c.png 611w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/c122ae16a4459711c028dc0469e7198c-300x180.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/li>\n<li><strong>Logarithmic &#8211;<\/strong> This trendline should be used when the data increase\/decrease quickly and then levels out.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/fc6d11ff305ea7fff7190b11c420239e.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone wp-image-18136 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/fc6d11ff305ea7fff7190b11c420239e.png\" alt=\"How to add Trendline in Excel Charts\" width=\"608\" height=\"372\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/fc6d11ff305ea7fff7190b11c420239e.png 608w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/fc6d11ff305ea7fff7190b11c420239e-300x184.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/a><\/li>\n<li><strong>Polynomial &#8211;<\/strong> It is a curved line that should be used when data fluctuates more than one rise and fall.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/a7dc97b28c1a0b0e0bcec4c789969f15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18137\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/a7dc97b28c1a0b0e0bcec4c789969f15.png\" alt=\"How to add Trendline in Excel Charts\" width=\"609\" height=\"375\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/a7dc97b28c1a0b0e0bcec4c789969f15.png 609w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/a7dc97b28c1a0b0e0bcec4c789969f15-300x185.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/a><\/li>\n<li><strong>Moving Average &#8211;\u00a0<\/strong> It is used to smooth the extreme fluctuations of data and show a clearer direction to data trends.<br \/>\n<h3><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/b1e5e4e31fbe6364bc7018ccff7c0342.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18138\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/b1e5e4e31fbe6364bc7018ccff7c0342.png\" alt=\"How to add Trendline in Excel Charts\" width=\"611\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/b1e5e4e31fbe6364bc7018ccff7c0342.png 611w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/b1e5e4e31fbe6364bc7018ccff7c0342-300x178.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/h3>\n<\/li>\n<\/ul>\n<h3><a id=\"format-the-trendline\"><\/a>Format the Trendline<\/h3>\n<p>Now that you know <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-slope-of-tangent-line-in-excel\/\" target=\"_blank\" rel=\"noopener\">how to add trendlin<\/a>e in Excel, let&#8217;s move forward to understand how to format them. You can change the color, transparency, width, dash type, compound type, cap type, and more for your trendline.<\/p>\n<p>In the example below, you want to change the color of the trendline to blue, increase the width to 2.5, and change the dash type.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Right-click on the <strong>Trendline.<\/strong><\/p>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-182.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17889\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-182.png\" alt=\"How to add Trendline in Excel Charts\" width=\"663\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-182.png 663w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-182-300x176.png 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Select the <strong>Format Trendline<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-183.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17890\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-183.png\" alt=\"How to add Trendline in Excel Charts\" width=\"698\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-183.png 698w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-183-300x162.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/a><\/p>\n<p>Or, you can skip STEP 1 &amp; 2 and simply <strong>double click on the trendline<\/strong> to open the Format Trendline pane.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>From the Format Trendline pane, click the <strong>Fill &amp; Line<\/strong> category.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-184.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17891\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-184.png\" alt=\"How to add Trendline in Excel Charts\" width=\"285\" height=\"504\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-184.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-184-170x300.png 170w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:\u00a0<\/strong><\/span>Select color &#8211; BLUE<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-185.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17892\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-185.png\" alt=\"How to add Trendline in Excel Charts\" width=\"290\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-185.png 290w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-185-185x300.png 185w\" sizes=\"(max-width: 290px) 100vw, 290px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span><\/strong> Change the width to 2.5<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-186.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17894\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-186.png\" alt=\"How to add Trendline in Excel Charts\" width=\"280\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-186.png 280w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-186-164x300.png 164w\" sizes=\"(max-width: 280px) 100vw, 280px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6<\/strong><\/span>: Change the dash type<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-187.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17895\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-187.png\" alt=\"How to add Trendline in Excel Charts\" width=\"284\" height=\"495\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-187.png 284w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-187-172x300.png 172w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/a><\/p>\n<p>Your formatted trendline is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-188.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17896\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-188.png\" alt=\"How to add Trendline in Excel Charts\" width=\"590\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-188.png 590w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-188-300x184.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<h3><a id=\"use-trendline-to-forecast-future-data\"><\/a>Use Trendline to Forecast Future Data<\/h3>\n<p>In Excel, you can extend your data and project the data trend into the future or past using the features of Trendline.<\/p>\n<p>In this example, you want to forecast sales for the next 6 periods. Follow the steps below to understand how to forecast data trends.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span>Double click on the trendline to open the <strong>Format Trendline pane.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone wp-image-3969 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png\" alt=\"How to add Trendline in Excel Charts\" width=\"582\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06.png 582w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Trendlines-06-300x180.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select the <strong>Trendline Options\u00a0<\/strong>tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-189.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17897\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-189.png\" alt=\"How to add Trendline in Excel Charts\" width=\"284\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-189.png 284w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-189-167x300.png 167w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Under <strong>forecast<\/strong>, type &#8220;6&#8221; in the <strong>forward box<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-190.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17898\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-190.png\" alt=\"How to add Trendline in Excel Charts\" width=\"284\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-190.png 284w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-190-171x300.png 171w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/a><\/p>\n<p>Your project data trend for the next 6 periods is created.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-191.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17899\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-191.png\" alt=\"How to add Trendline in Excel Charts\" width=\"600\" height=\"373\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-191.png 600w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-191-300x187.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>You can use trendline to extrapolate the trend of the data into the past. Simply type the period in the backward box instead of the forward box.<\/p>\n<h3><a id=\"add-multiple-trendline-to-same-chart\"><\/a>Add multiple trendline to same chart<\/h3>\n<p>Until now, you have learned how to add trendline in Excel. But you can add multiple trendlines to the same chart. Let&#8217;s see how it can be done.<\/p>\n<p>Say, you want to add both linear and moving average trendline to the existing data. Add the first linear trendline as discussed above and then follow the steps below to add another trendline.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1: <\/span><\/strong>Click on the<strong> Chart Elements<\/strong> (<strong>&#8220;+&#8221; icon)<\/strong> on the top-right corner of the chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-199.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18139\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-199.png\" alt=\"How to add Trendline in Excel Charts\" width=\"647\" height=\"396\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-199.png 647w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-199-300x184.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Click on the <strong>arrow next to Trendline<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-203.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18140\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-203.png\" alt=\"How to add Trendline in Excel Charts\" width=\"813\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-203.png 813w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-203-300x152.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-203-768x388.png 768w\" sizes=\"(max-width: 813px) 100vw, 813px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Select <strong>Two Period Moving Average<\/strong> from the list<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-204.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18141\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-204.png\" alt=\"How to add Trendline in Excel Charts\" width=\"1015\" height=\"402\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-204.png 1015w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-204-300x119.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-204-768x304.png 768w\" sizes=\"(max-width: 1015px) 100vw, 1015px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4: <\/strong><span style=\"color: #000000\">Select the series <strong>SALES.<\/strong><\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-205.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18143\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-205.png\" alt=\"How to add Trendline in Excel Charts\" width=\"639\" height=\"418\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-205.png 639w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-205-300x196.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/a><\/p>\n<p>Excel will show both the trendlines on the same chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-206.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-18144\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-206.png\" alt=\"How to add Trendline in Excel Charts\" width=\"655\" height=\"425\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-206.png 655w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-206-300x195.png 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/><\/a><\/p>\n<div>\n<div>\n<h3><a id=\"how-to-remove-trendline-in-excel\"><\/a>How to remove trendline in Excel<\/h3>\n<p>Removing the trendline in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/gauge-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel Chart<\/a> is extremely easy and a quick process. Let&#8217;s see how it is done.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Click on the <strong>Excel Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17901\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png\" alt=\"How to add Trendline in Excel Charts\" width=\"602\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192.png 602w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-192-300x186.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Click on the<strong> Chart Elements<\/strong> (<strong>&#8220;+&#8221; icon)<\/strong> on the top-right corner of the chart.<\/p>\n<\/div>\n<p><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-193.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17902\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-193.png\" alt=\"How to add Trendline in Excel Charts\" width=\"672\" height=\"394\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-193.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-193-300x176.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/strong><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> From the dropdown, <strong>uncheck Trendline.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-194.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17903\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-194.png\" alt=\"How to add Trendline in Excel Charts\" width=\"802\" height=\"402\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-194.png 802w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-194-300x150.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-194-768x385.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<p>Or, you could simply <strong>right click on the trendline<\/strong> and click on delete.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-195.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to add Trendline in Excel Charts\" class=\"alignnone size-full wp-image-17904\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-195.png\" alt=\"How to add Trendline in Excel Charts\" width=\"607\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-195.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-195-300x179.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>In this tutorial, you have covered how to add trendline in Excel, the different types of trendlines, formatting the trendline, extending the trendline into future or past periods, adding multiple trendlines to the same chart, and finally how to remove them.<\/p>\n<p><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/excel-2016-charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">You can learn more about Excel Charts by going through these blogs!<\/a><\/strong><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/61-excel-charts-examples\/\" target=\"_blank\" rel=\"noopener\">61 Excel Charts Examples!<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-milestone-chart-using-excel\/\" target=\"_blank\" rel=\"noopener\">Project Milestone Chart Using Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-chart-settings\/\" target=\"_blank\" rel=\"noopener\">Pivot Chart Settings<\/a><\/li>\n<\/ul>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>, and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a>!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With Excel Charts,\u00a0it is very easy to create Trendlines\u00a0for your data. \u00a0Trendlines\u00a0show which direction the trend of your data is going, and gives you the trajectory as well. In this tutorial, you will cover all of these sub-topics in details: How to add trendline in Excel Different types of trendline Format the Trendline Use trendline [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14711,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to add Trendline in Excel Charts","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,26],"tags":[160,159,158],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3961"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3961"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14711"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}