{"id":14892,"date":"2023-02-20T11:54:44","date_gmt":"2023-02-20T11:54:44","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=14892"},"modified":"2024-03-26T10:29:18","modified_gmt":"2024-03-26T10:29:18","slug":"add-target-line-to-excel-chart","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/","title":{"rendered":"Add Target Line to Excel Chart"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-43280204-081d-49d4-bb06-b43c5cbe161a\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/Add-Target-Line-to-Excel-Chart.xlsx\">Add-Target-Line-to-Excel-Chart<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/Add-Target-Line-to-Excel-Chart.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-43280204-081d-49d4-bb06-b43c5cbe161a\">Download File<\/a><\/div>\n\n\n\n<p><strong>Excel Charts<\/strong> are one of the best tools at our disposal in terms of the virtual presentation of our data. When we want to present the achieved results, we often want to have a certain threshold value or a target to compare the results with.<\/p>\n\n\n\n<p>In the example below, we will show how to <strong>add a target line to Excel Chart<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Add Target Line to Excel Chart<\/h2>\n\n\n\n<p>We will first create a table with sales data achieved in a particular month:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"253\" height=\"337\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png\" alt=\"\" class=\"wp-image-14894\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png 253w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1-225x300.png 225w\" sizes=\"(max-width: 253px) 100vw, 253px\" \/><\/figure>\n\n\n\n<p>We will create a simple graph from these numbers, by selecting the table and then going to <strong>Insert &gt;&gt; Charts &gt;&gt; Recommended Charts<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1146\" height=\"546\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-2.png\" alt=\"\" class=\"wp-image-14895\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-2.png 1146w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-2-300x143.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-2-1024x488.png 1024w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-2-768x366.png 768w\" sizes=\"(max-width: 1146px) 100vw, 1146px\" \/><\/figure>\n\n\n\n<p>On the <strong>Recommended Charts window<\/strong>, we will choose <strong>Clustered Column<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"750\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-3.png\" alt=\"\" class=\"wp-image-14896\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-3.png 794w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-3-300x283.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-3-768x725.png 768w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><\/figure>\n\n\n\n<p>Excel will neatly present us with the <strong>Chart<\/strong> that we are actually going to get, so when we <strong>click OK<\/strong>, we will end up with the same chart that we see in the picture above.<\/p>\n\n\n\n<p>Now we need to <strong>add an<\/strong> <strong>actual target<\/strong> to our sales figures, to see if the sales results are above or below the targeted figure.<\/p>\n\n\n\n<p>Our target figure will be <strong>$400,000<\/strong>, and we will insert this number in <strong>column C<\/strong>, and it will be the same for all months:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"359\" height=\"345\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-4.png\" alt=\"\" class=\"wp-image-14897\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-4.png 359w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-4-300x288.png 300w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/figure>\n\n\n\n<p>We have two ways in which we could <strong>add target figures<\/strong> to our chart. The easiest one is to <strong>click on the Chart<\/strong>, and then <strong>drag the chart data<\/strong> to include <strong>column C<\/strong> as well:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1051\" height=\"460\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-5.png\" alt=\"\" class=\"wp-image-14898\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-5.png 1051w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-5-300x131.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-5-1024x448.png 1024w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-5-768x336.png 768w\" sizes=\"(max-width: 1051px) 100vw, 1051px\" \/><\/figure>\n\n\n\n<p>By doing so, our chart will significantly change, and another bar will be added for the target:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1026\" height=\"483\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-6.png\" alt=\"\" class=\"wp-image-14899\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-6.png 1026w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-6-300x141.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-6-1024x482.png 1024w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-6-768x362.png 768w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><\/figure>\n\n\n\n<p>We could have also used the <strong>Chart Design tab<\/strong> to add our column. We would need to choose <strong>Select Data <\/strong>from it:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"158\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-7.png\" alt=\"\" class=\"wp-image-14900\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-7.png 659w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-7-300x72.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/figure>\n\n\n\n<p>We would basically have to add the target to our series, or change the chart data range to <strong>include column C <\/strong>as well:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"407\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-8.png\" alt=\"\" class=\"wp-image-14901\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-8.png 715w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-8-300x171.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/figure>\n\n\n\n<p>Although we do have all the data needed at this point, it would be better to present the target on a line, rather than in bars. To do this, we will <strong>right-click on the chart<\/strong>, and then choose <strong>Change Chart Type<\/strong> as an option:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"388\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-9.png\" alt=\"\" class=\"wp-image-14902\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-9.png 678w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-9-300x172.png 300w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Under the dropdown menu, we will choose a <strong>Combo chart<\/strong>, and put our <strong>Target in one Line<\/strong>, which will give us a nice visual presentation:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"756\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-10.png\" alt=\"\" class=\"wp-image-14903\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-10.png 796w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-10-300x285.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-10-768x729.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<p>When we <strong>click OK<\/strong>, we will have the same chart presented in our Excel file, as it was presented in the picture above:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1068\" height=\"521\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-11.png\" alt=\"\" class=\"wp-image-14904\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-11.png 1068w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-11-300x146.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-11-1024x500.png 1024w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-11-768x375.png 768w\" sizes=\"(max-width: 1068px) 100vw, 1068px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Excel Charts are one of the best tools at our disposal in terms of the virtual presentation of our data. When we want&#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 Target Line to Excel Chart<\/title>\n<meta name=\"description\" content=\"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.\" \/>\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-target-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 Target Line to Excel Chart\" \/>\n<meta property=\"og:description\" content=\"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-20T11:54:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T10:29:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.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-target-line-to-excel-chart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Add Target Line to Excel Chart\",\"datePublished\":\"2023-02-20T11:54:44+00:00\",\"dateModified\":\"2024-03-26T10:29:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\"},\"wordCount\":397,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\",\"name\":\"Add Target Line to Excel Chart\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png\",\"datePublished\":\"2023-02-20T11:54:44+00:00\",\"dateModified\":\"2024-03-26T10:29:18+00:00\",\"description\":\"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png\",\"width\":253,\"height\":337},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Add Target 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 Target Line to Excel Chart","description":"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.","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-target-line-to-excel-chart\/","og_locale":"en_US","og_type":"article","og_title":"Add Target Line to Excel Chart","og_description":"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.","og_url":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/","article_published_time":"2023-02-20T11:54:44+00:00","article_modified_time":"2024-03-26T10:29:18+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.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-target-line-to-excel-chart\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Add Target Line to Excel Chart","datePublished":"2023-02-20T11:54:44+00:00","dateModified":"2024-03-26T10:29:18+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/"},"wordCount":397,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/","url":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/","name":"Add Target Line to Excel Chart","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png","datePublished":"2023-02-20T11:54:44+00:00","dateModified":"2024-03-26T10:29:18+00:00","description":"Learn how to add a target line to Excel chart with our step-by-step guide. Download the example file and start presenting your data like a pro.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14892-1.png","width":253,"height":337},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/add-target-line-to-excel-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Add Target 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\/14892"}],"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=14892"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14892\/revisions"}],"predecessor-version":[{"id":14907,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14892\/revisions\/14907"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=14892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=14892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=14892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}