{"id":599,"date":"2014-10-06T18:07:41","date_gmt":"2014-10-06T16:07:41","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=599"},"modified":"2024-03-23T21:31:55","modified_gmt":"2024-03-23T20:31:55","slug":"line-chart-trend-with-lots-of-data","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/line-chart-trend-with-lots-of-data\/","title":{"rendered":"Line Chart: Trend with lots of data"},"content":{"rendered":"<p>A Line Chart is used in Excel when you have <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/grouped-bar-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">lots of data<\/a> points and want to show a periodic trend.<\/p>\n<p>An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I show below.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/BfvSp-asg_o?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><\/iframe><\/p>\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=\"alignmiddle 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><br \/>\n<span style=\"color: #0000ff\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Line-Chart.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Line-Chart.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>\u00a0Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?ii=1173607&amp;c=ib&amp;aff=277028&amp;cl=49044\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Clustered Bar Chart: Year to Date Sales\" class=\"alignnone wp-image-670 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/project-management-bundle-excel-ad-2.png\" alt=\"Clustered Bar Chart: Year to Date Sales\" width=\"572\" height=\"141\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/project-management-bundle-excel-ad-2.png 572w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/project-management-bundle-excel-ad-2-300x74.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend. An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I show below. \ufeff [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17585,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,26],"tags":[94,99],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/599"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=599"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/599\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17585"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}