{"id":10501,"date":"2022-07-07T08:25:37","date_gmt":"2022-07-07T08:25:37","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=10501"},"modified":"2024-03-26T10:24:36","modified_gmt":"2024-03-26T10:24:36","slug":"add-horizontal-line-to-excel-chart","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/","title":{"rendered":"Add Horizontal Line to Excel Chart"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f0d552ff-8fb0-4c2a-8eb6-8395509266a3\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Add-Horizontal-Line-to-Excel-Chart.xlsx\">Add-Horizontal-Line-to-Excel-Chart<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Add-Horizontal-Line-to-Excel-Chart.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f0d552ff-8fb0-4c2a-8eb6-8395509266a3\">Download File<\/a><\/div>\n\n\n\n<p>We have already explained the possibility of adding a vertical line to the Excel Bar Chart. However, there is also a possibility of going in a different direction- adding a <strong>horizontal line to an Excel chart<\/strong>.<\/p>\n\n\n\n<p>We will show how to do it in the example below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Add Horizontal Line to Clustered Column<\/h2>\n\n\n\n<p>To show the addition of the <a href=\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-and-vertical-lines-in-excel-cells\/\">horizontal line<\/a>, we will use <strong>Clustered Column chart<\/strong>, as this chart is one of the most widely used ones.<\/p>\n\n\n\n<p>We will create it based on the data of <strong>NBA players and their points<\/strong> in one night of basketball:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"186\" height=\"242\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\" alt=\"Text, table\n\nDescription automatically generated with medium confidence\" class=\"wp-image-10502\"\/><\/figure>\n\n\n\n<p>After doing that, we will resort to creating a simple <strong>Clustered Column chart<\/strong>, by selecting our range (<strong>A1:B11<\/strong>) and then going to <strong>Insert tab &gt;&gt; Charts<\/strong> and finding and choosing <strong>Clustered Column chart<\/strong> that is located under <strong>2-D Columns<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"514\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-description-5.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-10503\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-description-5.png 732w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-description-5-300x211.png 300w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/figure>\n\n\n\n<p>It is noticeable that we get the preview of our chart, and when we choose it, it will be the same, as shown in the picture below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"492\" height=\"301\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-4.png\" alt=\"Chart, bar chart\n\nDescription automatically generated\" class=\"wp-image-10504\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-4.png 492w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-4-300x184.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/figure>\n\n\n\n<p>Now we need to create an additional table with <strong>x and y values<\/strong> (<strong>horizontal and vertical ones<\/strong>). We want to present the average values horizontally, so our <strong>x values<\/strong> will be equal to the <strong>averages of all the points<\/strong> (two values), while the <strong>y values will be values 0 and 10<\/strong> (the number of players in our table):<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"181\" height=\"133\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-description-automaticall.png\" alt=\"Graphical user interface\n\nDescription automatically generated\" class=\"wp-image-10505\"\/><\/figure>\n\n\n\n<p>We will then copy this data (<strong>range D2:E3<\/strong>), click on our chart, and go to the <strong>Home tab<\/strong>, where we will find <strong>Paste special option<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"386\" height=\"299\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-table-exce-1.png\" alt=\"Graphical user interface, application, table, Excel\n\nDescription automatically generated\" class=\"wp-image-10506\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-table-exce-1.png 386w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-table-exce-1-300x232.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n\n\n\n<p>In a window that appears when we click on <strong>Paste Special<\/strong>, we will choose <strong>New series <\/strong>under <strong>Add cells as an <\/strong>option, <strong>Columns <\/strong>in <strong>Values (Y)<\/strong>, and click on <strong>Categories (X Labels) in First Column<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"229\" height=\"214\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-description-6.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-10507\"\/><\/figure>\n\n\n\n<p>When we <strong>click OK<\/strong>, we will have the chart presented as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"492\" height=\"304\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-5.png\" alt=\"Chart, bar chart\n\nDescription automatically generated\" class=\"wp-image-10508\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-5.png 492w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-5-300x185.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/figure>\n\n\n\n<p>To make these <strong>two orange lines horizontal<\/strong>, we need to change the type of our chart. We will do so by clicking on it, and then choosing the <strong>Change Chart Type <\/strong>option:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"353\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-description-automatically-generated-2.png\" alt=\"Chart\n\nDescription automatically generated\" class=\"wp-image-10509\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-description-automatically-generated-2.png 639w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-description-automatically-generated-2-300x166.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/figure>\n\n\n\n<p>On the window that appears, we need to choose <strong>Combo chart<\/strong> at the end of it, and then choose <strong>Scatter with Straight Lines<\/strong> as a <strong>chart for Series2<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"605\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-2.png\" alt=\"Graphical user interface, application, Word\n\nDescription automatically generated\" class=\"wp-image-10510\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-2.png 635w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-2-300x286.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/figure>\n\n\n\n<p>We can still see that the average line is not where it should be. For the full effect, we need to <strong>uncheck<\/strong> the <strong>Secondary Axis button<\/strong> for <strong>Series2<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"605\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-3.png\" alt=\"Graphical user interface, application, Word\n\nDescription automatically generated\" class=\"wp-image-10511\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-3.png 638w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/graphical-user-interface-application-word-descr-3-300x284.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/figure>\n\n\n\n<p>As seen in the preview, we will have our data presented in the way we want. We will click <strong>OK<\/strong> and have our chart set:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"301\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-6.png\" alt=\"Chart, bar chart\n\nDescription automatically generated\" class=\"wp-image-10512\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-6.png 487w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-6-300x185.png 300w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/figure>\n\n\n\n<p>As seen, we lost the title of our chart along the way. To add it again, we will simply click on the chart, then on the <strong>plus sign on the upper right side<\/strong>, and choose <strong>Chart Title<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"320\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-7.png\" alt=\"Chart, bar chart\n\nDescription automatically generated\" class=\"wp-image-10513\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-7.png 720w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/chart-bar-chart-description-automatically-genera-7-300x133.png 300w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>Then we can insert whatever we want- <strong>Points<\/strong> in our case.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have already explained the possibility of adding a vertical line to the Excel Bar Chart. However, there is also a possibility of&#8230;<\/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":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Add Horizontal Line to Excel Chart<\/title>\n<meta name=\"description\" content=\"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Add Horizontal Line to Excel Chart\" \/>\n<meta property=\"og:description\" content=\"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-07T08:25:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T10:24:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Add Horizontal Line to Excel Chart\",\"datePublished\":\"2022-07-07T08:25:37+00:00\",\"dateModified\":\"2024-03-26T10:24:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\"},\"wordCount\":464,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\",\"name\":\"Add Horizontal Line to Excel Chart\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\",\"datePublished\":\"2022-07-07T08:25:37+00:00\",\"dateModified\":\"2024-03-26T10:24:36+00:00\",\"description\":\"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Add Horizontal Line to Excel Chart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Add Horizontal Line to Excel Chart","description":"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!","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:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/","og_locale":"en_US","og_type":"article","og_title":"Add Horizontal Line to Excel Chart","og_description":"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!","og_url":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/","article_published_time":"2022-07-07T08:25:37+00:00","article_modified_time":"2024-03-26T10:24:36+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Add Horizontal Line to Excel Chart","datePublished":"2022-07-07T08:25:37+00:00","dateModified":"2024-03-26T10:24:36+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/"},"wordCount":464,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/","url":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/","name":"Add Horizontal Line to Excel Chart","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png","datePublished":"2022-07-07T08:25:37+00:00","dateModified":"2024-03-26T10:24:36+00:00","description":"Learn how to add a horizontal line to an Excel chart with this step-by-step guide. Download the Excel file and try it yourself!","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/text-table-description-automatically-generated-w.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/add-horizontal-line-to-excel-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Add Horizontal Line to Excel Chart"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10501"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=10501"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10501\/revisions"}],"predecessor-version":[{"id":13881,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10501\/revisions\/13881"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=10501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=10501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=10501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}