{"id":18962,"date":"2022-11-25T19:12:00","date_gmt":"2022-11-25T19:12:00","guid":{"rendered":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/"},"modified":"2022-11-25T19:12:00","modified_gmt":"2022-11-25T19:12:00","slug":"how-to-add-a-trendline-in-google-sheets","status":"publish","type":"post","link":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/","title":{"rendered":"How to Add a Trendline in Google Sheets"},"content":{"rendered":"<p> <a href=\"https:\/\/go.fiverr.com\/visit\/?bta=1052423&nci=17043\" Target=\"_Top\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" src=\"https:\/\/fiverr.ck-cdn.com\/tn\/serve\/?cid=40081059\" loading=\"lazy\"  width=\"601\" height=\"201\"><\/a>\n<\/p>\n<div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-741481 size-full\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"The Google Sheets logo.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>First, add a chart to your Google sheet. You can then edit the chart&#8212;in the Chart Editor, select the &#8220;Customize&#8221; tab in the sidebar, select &#8220;Series,&#8221; check the &#8220;Trendline&#8221; box, and customize your trendline&#8217;s settings.<\/p>\n<p>If you want a simple visual to help your audience see the direction of the data in your chart, consider a trendline. You can <a href=\"https:\/\/www.howtogeek.com\/798850\/how-to-add-a-trendline-in-microsoft-excel\/\">add different types of trendlines<\/a> in Google Sheets and customize their appearance.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><a name=\"autotoc_anchor_0\"\/>About Trendlines in Google Sheets<\/h2>\n<p>You can add a trendline to a <a href=\"https:\/\/www.howtogeek.com\/768192\/how-to-make-a-bar-graph-in-google-sheets\/\">bar graph<\/a>, column chart, <a href=\"https:\/\/www.howtogeek.com\/767761\/how-to-make-a-line-graph-in-google-sheets\/\">line graph<\/a>, or scatter chart. You can select a specific series for the trendline or apply one to all the series in the chart.<\/p>\n<p><strong>RELATED:<\/strong> <a href=\"https:\/\/www.howtogeek.com\/768192\/how-to-make-a-bar-graph-in-google-sheets\/\"><strong><em>How to Make a Bar Graph in Google Sheets<\/em><\/strong><\/a><\/p>\n<p>There are six types of trendlines you can use depending on how you want to display the line:<\/p>\n<ul>\n<li><strong>Linear:<\/strong> Use this for data that mostly follows a straight line.<\/li>\n<li><strong>Exponential:<\/strong> Use this for data that increases and decreases in proportion to its value.<\/li>\n<li><strong>Polynomial:<\/strong> Use this for data that fluctuates.<\/li>\n<li><strong>Logarithmic:<\/strong> Use this for data that increases and decreases quickly and then levels out.<\/li>\n<li><strong>Power Series:<\/strong> Use this for data that increases and decreases in proportion to its value at the same rate.<\/li>\n<li><strong>Moving Average:<\/strong> Use this to help even out unstable data.<\/li>\n<\/ul>\n<h2 role=\"heading\" aria-level=\"2\"><a name=\"autotoc_anchor_1\"\/>Add a Trendline in Google Sheets<\/h2>\n<p>Once you <a href=\"https:\/\/www.howtogeek.com\/446699\/how-to-make-a-graph-in-google-sheets\/\">have the chart<\/a> you want to use and are ready to add the trendline, double-click the chart or click the three dots on the top right and select \u201cEdit Chart\u201d to open the Chart Editor sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837198\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/EditChart-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Edit Chart in the chart menu\" width=\"650\" height=\"340\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to the Customize tab in the sidebar and expand the Series section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837199\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/CustomizeSeries-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Series section on the Customize tab of the Chart Editor\" width=\"318\" height=\"395\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>At the top of the section, use the drop-down box to choose the series you want to use for the trendline. You can choose \u201cApply to All Series\u201d or select a particular one in your chart.<\/p>\n<p>If you want to customize a trendline for each series, simply select one at a time and follow the steps below for each.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837203\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/SelectSeries-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Select a chart Series\" width=\"309\" height=\"187\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Scroll to the bottom of the Series section and check the box for Trendline.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837204\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/CheckboxTrendline-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Trendline box checked\" width=\"318\" height=\"396\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the trendline appear on your chart. From there, use the Type drop-down box directly beneath to select the kind of trendline you want to use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837201\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/SelectType-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Trendline type selection\" width=\"318\" height=\"396\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you select Polynomial, you can pick the degree. If you select Moving Average, you can pick the Average Type and Period.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837206\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PolynomialMovingAverage-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Polynomial and Moving Average trendline types\" width=\"623\" height=\"177\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you have your trendline set up, you can customize its appearance.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><a name=\"autotoc_anchor_2\"\/>Customize a Trendline in Your Chart<\/h2>\n<p><a href=\"https:\/\/www.howtogeek.com\/687888\/how-to-switch-chart-axes-in-google-sheets\/\">With the Chart Editor<\/a> sidebar open and the Series section expanded on the Customize tab, you\u2019ll see options to customize the trendline.<\/p>\n<p><strong>RELATED:<\/strong> <a href=\"https:\/\/www.howtogeek.com\/687888\/how-to-switch-chart-axes-in-google-sheets\/\"><strong><em>How to Switch Chart Axes in Google Sheets<\/em><\/strong><\/a><\/p>\n<p>You can select a Line Color using the palette drop-down box. This is handy if you want the trendline to stand out.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837209\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/LineColor-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Line color palette for a trendline\" width=\"650\" height=\"372\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you can adjust the Line Opacity using the drop-down box. Pick from zero to 100% to make the line more or less bold.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837210\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/LineOpacity-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Opacity options for a trendline\" width=\"650\" height=\"439\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then pick the Line Thickness using the drop-down box. Select one, two, four, or eight pixels for the width of the line.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837208\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/LineThickness-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Line Thickness options for a trendline\" width=\"650\" height=\"283\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Finally, you can add a label for your trendline to the chart legend if you like. Select the type in the Label drop-down box. If you choose \u201cCustom,\u201d enter the text for the label in the next box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837212\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/LabelCustom-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Custom label for a trendline\" width=\"650\" height=\"324\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also choose \u201cUse Equation\u201d to display the trendline type\u2019s equation as the label and optionally display the R squared for how closely the trendline fits the chart data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837211\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ShowRSquared-GoogleSheetsTrendline.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" loading=\"lazy\" alt=\"Show R squared box checked for a trendline\" width=\"650\" height=\"324\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" loading=\"lazy\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish adding and customizing your trendline, use the \u201cX\u201d on the top right of the Chart Editor sidebar to close it.<\/p>\n<p>If you want an added visual to help your viewers capture the direction of your data, a trendline in Google Sheets is the way to go.<\/p>\n<p>For more, check out how to <a href=\"https:\/\/www.howtogeek.com\/777718\/how-to-save-or-publish-a-chart-from-google-sheets\/\">save or publish a chart<\/a> or learn how to\u00a0<a href=\"https:\/\/www.howtogeek.com\/798871\/how-to-make-a-table-chart-in-google-sheets-using-a-chart\/\">make a table using a chart<\/a> in Google Sheets.<\/p>\n<\/div>\n<iframe data-lazy=\"true\" data-src=\"https:\/\/www.fiverr.com\/gig_widgets?id=U2FsdGVkX18x7XQvttUTrv1oEqmGNGTgvvCUiUoJ\/AP4z\/UyMz8lXGOLpu15jIMxBbTR0gmD5uBoFvhC4KWeALQRp3h\/X\/AwcVD0K8Wj9H\/ZzYKzcCNHosB9oS4SCJJFWiN85P9ICAc4OgCoE\/wHKIY7CDkf2\/DQ1vqGvk4smVe5cRDEmrLPCWi4FC8p40VUhSmWQ5udCm0zoJtorgWv3vbDQw0kKYkwn39ozAnQXDe+YvWMxkLFWA+O3TFwkJvdkIK+\/AUSnRssPKt5WHY0FhNOxnSPcLslEL4G4\/RfP95ve99U+kRnDy3X+KtzdQLY+u935ghON\/o3UE4IMv9oN6JX9RnxzL\/LRcOgnHigxStSGPKsZYtnz8RWNVT\/rOLAibqiWJadC5MYHRbekF3eg6FOGrQGkXYbsn0+a5aovnlLCbLwIqY9fcS17UX8J235iQ6cdmHNbrPeS84CMm34RA==&affiliate_id=1052423&strip_google_tagmanager=true\" loading=\"lazy\" data-with-title=\"true\" class=\"fiverr_nga_frame\" frameborder=\"0\" height=\"350\" width=\"100%\" referrerpolicy=\"no-referrer-when-downgrade\" data-mode=\"random_gigs\" onload=\" var frame = this; var script = document.createElement('script'); script.addEventListener('load', function() { window.FW_SDK.register(frame); }); script.setAttribute('src', 'https:\/\/www.fiverr.com\/gig_widgets\/sdk'); document.body.appendChild(script); \" ><\/iframe>\n<br \/><a href=\"https:\/\/www.howtogeek.com\/837193\/how-to-add-a-trendline-in-google-sheets\/\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, add a chart to your Google sheet. You can then edit the chart&#8212;in the Chart Editor, select the &#8220;Customize&#8221; tab in the sidebar, select&#8230;<\/p>\n","protected":false},"author":1,"featured_media":18963,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-18962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-universe"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Add a Trendline in Google Sheets - mailinvest.blog<\/title>\n<meta name=\"description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Add a Trendline in Google Sheets - mailinvest.blog\" \/>\n<meta property=\"og:description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"mailinvest.blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/freelanceracademic\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T19:12:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2392\" \/>\n\t<meta property=\"og:image:height\" content=\"1342\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin@mailinvest.blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin@mailinvest.blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/\"},\"author\":{\"name\":\"admin@mailinvest.blog\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\"},\"headline\":\"How to Add a Trendline in Google Sheets\",\"datePublished\":\"2022-11-25T19:12:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/\"},\"wordCount\":668,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Google-Sheets-Logo-Lede.png\",\"articleSection\":[\"Tech Universe\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/\",\"name\":\"How to Add a Trendline in Google Sheets - mailinvest.blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Google-Sheets-Logo-Lede.png\",\"datePublished\":\"2022-11-25T19:12:00+00:00\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Google-Sheets-Logo-Lede.png\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Google-Sheets-Logo-Lede.png\",\"width\":2392,\"height\":1342},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/25\\\/how-to-add-a-trendline-in-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mailinvest.blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Add a Trendline in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"name\":\"mailinvest.blog\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mailinvest.blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\",\"name\":\"mailinvest\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"width\":1000,\"height\":1000,\"caption\":\"mailinvest\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/freelanceracademic\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\",\"name\":\"admin@mailinvest.blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"caption\":\"admin@mailinvest.blog\"},\"sameAs\":[\"https:\\\/\\\/mailinvest.blog\",\"admin@mailinvest.blog\"],\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/author\\\/adminmailinvest-blog\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Add a Trendline in Google Sheets - mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Add a Trendline in Google Sheets - mailinvest.blog","og_description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","og_url":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/","og_site_name":"mailinvest.blog","article_publisher":"https:\/\/www.facebook.com\/freelanceracademic\/","article_published_time":"2022-11-25T19:12:00+00:00","og_image":[{"width":2392,"height":1342,"url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png","type":"image\/png"}],"author":"admin@mailinvest.blog","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin@mailinvest.blog","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#article","isPartOf":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/"},"author":{"name":"admin@mailinvest.blog","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4"},"headline":"How to Add a Trendline in Google Sheets","datePublished":"2022-11-25T19:12:00+00:00","mainEntityOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/"},"wordCount":668,"commentCount":0,"publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png","articleSection":["Tech Universe"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/","url":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/","name":"How to Add a Trendline in Google Sheets - mailinvest.blog","isPartOf":{"@id":"https:\/\/mailinvest.blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png","datePublished":"2022-11-25T19:12:00+00:00","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","breadcrumb":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#primaryimage","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/Google-Sheets-Logo-Lede.png","width":2392,"height":1342},{"@type":"BreadcrumbList","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/25\/how-to-add-a-trendline-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mailinvest.blog\/"},{"@type":"ListItem","position":2,"name":"How to Add a Trendline in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/mailinvest.blog\/#website","url":"https:\/\/mailinvest.blog\/","name":"mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mailinvest.blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mailinvest.blog\/#organization","name":"mailinvest","url":"https:\/\/mailinvest.blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","width":1000,"height":1000,"caption":"mailinvest"},"image":{"@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/freelanceracademic\/"]},{"@type":"Person","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4","name":"admin@mailinvest.blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","caption":"admin@mailinvest.blog"},"sameAs":["https:\/\/mailinvest.blog","admin@mailinvest.blog"],"url":"https:\/\/mailinvest.blog\/index.php\/author\/adminmailinvest-blog\/"}]}},"_links":{"self":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/18962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/comments?post=18962"}],"version-history":[{"count":0,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/18962\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media\/18963"}],"wp:attachment":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media?parent=18962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/categories?post=18962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/tags?post=18962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}