{"id":12425,"date":"2018-03-31T10:06:40","date_gmt":"2018-03-31T10:06:40","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12425"},"modified":"2025-02-27T13:04:23","modified_gmt":"2025-02-27T07:34:23","slug":"tableau-reference-lines","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/","title":{"rendered":"Tableau Reference Lines &#8211; Add Reference Lines in Tableau"},"content":{"rendered":"<p>In this <strong><a href=\"https:\/\/data-flair.training\/blogs\/tableau-download\/\">Tableau tutorial,<\/a><\/strong> we will study what is Tableau Reference Lines with example and the steps involved in creating \/ Adding reference lines to the <strong><a href=\"https:\/\/data-flair.training\/blogs\/tableau-bar-chart\/\">Tableau Bar Chart<\/a><\/strong>. So, let us start!!!<\/p>\n<h3>Tableau Reference Lines<\/h3>\n<p>A reference line in Tableau is simply a line that gets drawn on a chart that represents another measure or point of reference. These are useful in providing context to the related chart. For example, a line showing the median will visually show the difference of each mark in the chart relative to the median.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/tableau-constant-line\/\"><strong>Read about Tableau Constant Line in detail<\/strong><\/a><\/p>\n<h3>How to Add Reference Line to Bar Chart in Tableau?<\/h3>\n<p>Using the following steps, we can create Reference lines in Tableau.<\/p>\n<p>i. From Dimensions, drag Year to Rows.<\/p>\n<p>ii. From Dimensions, drag Genre to Rows to the right of the Year pill.<\/p>\n<p>iii. From Measures, drag Worldwide Gross Amount to Columns.<\/p>\n<p>iv. Hover over the Worldwide Gross Amount axis, and click on the sort icon once to sort the bars in descending order.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/tableau-stacked-bar-chart\/\"><strong>Let&#8217;s Study About Tableau Stacked Bar Chart<\/strong><\/a><\/p>\n<p>v. On the sidebar, click on the Analytics tab to activate it.<\/p>\n<p>vi. Under Custom, drag Reference Line from the Analytics tab and drop it onto the Table placeholder:<\/p>\n<div id=\"attachment_12428\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-416.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12428\" class=\"wp-image-12428 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-416.png\" alt=\"Tableau Reference Line\" width=\"585\" height=\"362\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-416.png 585w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-416-150x93.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-416-300x186.png 300w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/a><p id=\"caption-attachment-12428\" class=\"wp-caption-text\">Step. 6 Adding Tableau Reference Line in Bar\u00a0Chart<\/p><\/div>\n<p>vii. Set the following for this Tableau reference lines:<\/p>\n<ul>\n<li>Scope as Entire Table<\/li>\n<li>Under Line, setValue, set the aggregation to Average of the SUM(Worldwide Gross Amount)<\/li>\n<li>Under Line Label, set it to Custom with Average &lt;Value&gt; as text; note you can use the &gt; button to insert values<\/li>\n<li>Under Formatting, set Line to a thick, dark red line<\/li>\n<li>Under Formatting, set Fill Above: to None<\/li>\n<li>In Under Formatting, set Fill Below: to None:<\/li>\n<\/ul>\n<div id=\"attachment_12429\" style=\"width: 449px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-417.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12429\" class=\"wp-image-12429 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-417.png\" alt=\"Tableau Reference Lines\" width=\"439\" height=\"448\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-417.png 439w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-417-147x150.png 147w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-417-294x300.png 294w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><p id=\"caption-attachment-12429\" class=\"wp-caption-text\">Step. 7 Adding Tableau Reference Line\u00a0in Bar\u00a0Chart<\/p><\/div>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/tableau-trend-line\/\"><strong>Let&#8217;s look at Tableau Trend Line and How to\u00a0Create Trend Line <\/strong><\/a><\/p>\n<p>viii. Click OK when done.<\/p>\n<p>ix. Under Custom, drag Reference Line again from the Analytics tab and this time drop it onto Pane.<\/p>\n<p>x. Set the following for reference lines in Tableau:<\/p>\n<ul>\n<li>A scope is Per Pane<\/li>\n<li>Under Line Value, set the aggregation to Average of the SUM(Worldwide Gross Amount)<\/li>\n<li>Under Line Label, set it to Value<\/li>\n<li>In Under Formatting, set Line to a thick gray line<\/li>\n<li>Under Formatting, set Fill Above to None<\/li>\n<li>Under Formatting, set Fill Below to a light yellow color<\/li>\n<\/ul>\n<p>xi. Click OK when done.<\/p>\n<h4>Conclusion<\/h4>\n<p>Hence, in this Tableau tutorial, we studied about Tableau reference lines, steps involved in creating and adding them in Tableau bar chart. Furthermore, if you have any queries, feel free to ask in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this Tableau tutorial, we will study what is Tableau Reference Lines with example and the steps involved in creating \/ Adding reference lines to the Tableau Bar Chart. So, let us start!!! Tableau&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":12430,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[6279,11461,14396],"class_list":["post-12425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-how-to-make-tableau-reference-line","tag-reference-lines-in-tableau","tag-tableau-reference-lines"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tableau Reference Lines - Add Reference Lines in Tableau - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn what is Tableau reference Lines, how to create reference lines in tableau and add them to bar chart, Tableau reference line example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Reference Lines - Add Reference Lines in Tableau - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn what is Tableau reference Lines, how to create reference lines in tableau and add them to bar chart, Tableau reference line example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-31T10:06:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-27T07:34:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Reference Lines - Add Reference Lines in Tableau - DataFlair","description":"Learn what is Tableau reference Lines, how to create reference lines in tableau and add them to bar chart, Tableau reference line example","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:\/\/data-flair.training\/blogs\/tableau-reference-lines\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Reference Lines - Add Reference Lines in Tableau - DataFlair","og_description":"Learn what is Tableau reference Lines, how to create reference lines in tableau and add them to bar chart, Tableau reference line example","og_url":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-31T10:06:40+00:00","article_modified_time":"2025-02-27T07:34:23+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Reference Lines &#8211; Add Reference Lines in Tableau","datePublished":"2018-03-31T10:06:40+00:00","dateModified":"2025-02-27T07:34:23+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/"},"wordCount":462,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg","keywords":["How to make tableau reference line","Reference Lines in Tableau","Tableau Reference Lines"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/","url":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/","name":"Tableau Reference Lines - Add Reference Lines in Tableau - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg","datePublished":"2018-03-31T10:06:40+00:00","dateModified":"2025-02-27T07:34:23+00:00","description":"Learn what is Tableau reference Lines, how to create reference lines in tableau and add them to bar chart, Tableau reference line example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Reference-Line-01-1.jpg","width":1200,"height":628,"caption":"Tableau Reference Lines - Add Reference Lines in Tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-reference-lines\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Tableau Reference Lines &#8211; Add Reference Lines in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=12425"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12425\/revisions"}],"predecessor-version":[{"id":144255,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12425\/revisions\/144255"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/12430"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}