{"id":9774,"date":"2018-03-05T06:38:52","date_gmt":"2018-03-05T01:08:52","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=9774"},"modified":"2025-02-28T17:32:29","modified_gmt":"2025-02-28T12:02:29","slug":"tableau-bullet-graph","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/","title":{"rendered":"Bullet Chart in Tableau – Utilize your data to fullest with tableau bullet"},"content":{"rendered":"

In this tutorial, we are going to learn about bullet chart in Tableau. The bullet charts are an advance type visualizations which provide detailed information on the dataset. Here, we are going to learn the basics of a bullet chart and see how to create them in Tableau.<\/p>\n

What is Bullet Chart?<\/h3>\n

A bullet chart is an advanced sort of bar chart where we can compare two measures on a single bar. In a bullet chart, the primary measure is shown by the main dark bar on the front and the secondary measure is shown beneath the main bar as a reference line. Further, we can divide the reference line into segments like 50%, 80% and then 100%.<\/p>\n

Thus, we can say that bullet charts are one of the most informative charts occupying less space and accommodating more detail and data. Let us suppose that we want to compare two measures, actual sales and expected sales. So here, our primary measure meaning the dark line will be actual sales and the reference line will be expected sales.<\/p>\n

Using a bullet chart, we can easily have these two measures on a single bar of bullet chart. Then we can see whether or not our actual sales are lagging, equaling or exceeding the expected sales value using the visualization.<\/p>\n

Similarly, we can use a bullet chart as a gauge or measure visualization where we can compare measures with respect to each other and therefore analyze the progress of a measure.<\/p>\n

Get to know about\u00a0Tableau Bar Chart<\/a>\u00a0in detail.<\/strong><\/em><\/p>\n

How to Create Bullet Chart in Tableau?<\/h3>\n

Follow the steps given below to create a bullet chart in Tableau. We would suggest you to have your dataset uploaded in Tableau before you start making this chart. We are using a dataset of electronics store sales.<\/p>\n

Step 1:<\/h4>\n

Open a blank\/new sheet in a Tableau workbook with your dataset uploaded. We select one dimension field; Sub-category<\/em> and two measure fields; Profit<\/em> and Sales<\/em> from the list of fields. Then, we select the bullet graph<\/strong> option from the visualization pane. Click on Show Me<\/strong> option to access the visualization pane.\"select<\/a><\/p>\n

Step 2:<\/h4>\n

Now, we will get a bullet chart which will have bars with grey lines in the background and blue lines on top of that. The grey lines are known as reference lines and the blue ones are the actual lines. So, from our two selected measures, one will become the reference line and another will become the main line (blue). The reference line field is the one that is shown on the Detail<\/strong> card of the Marks<\/strong> section.\"bullet<\/a><\/p>\n

We can change or swap the two fields with each other. To make the reference line field as the main line field, right-click on the x-axis and select Swap Reference Line Fields<\/strong> option. Also, we can change the view type from Standard<\/strong> to Entire View<\/strong> so that the chart covers the entire sheet.\"entire<\/a><\/p>\n

Step 3:<\/h4>\n

Next, we set the aggregation type for our line. We select it as Average<\/strong>. You can also set the bar type, scope, line, label, tooltip, formatting of the bars and lines, etc from the editing box in tableau<\/a>. To access this editing box, right-click on the x-axis and select the Edit Axis<\/strong> option.\"bullet<\/a><\/p>\n

Step 4:<\/h4>\n

Now, we edit the reference line to put percentage-wise segments of average profit values on the reference line. To do this, we right-click on the Sales<\/strong> axis and select the Edit Reference Line<\/strong> option. Then, we select 50%,80% of the Average Profit<\/strong>.\"edit<\/a><\/p>\n

This opens a dialog box from where you can edit and format the computations of the reference line.\"percent<\/a><\/p>\n

By selecting the percent average option, the reference line divides itself into three segments. When you hover the cursor over the reference line, you will first see a 50% of Average Profit<\/strong> mark with the value.\"bullet<\/a><\/p>\n

Further ahead on the reference line, you will find 80% of the Average Profit<\/strong> mark with the value. In this way, we can see the main values on the blue bar and reference, more detailed values on the reference line.\"average<\/a><\/p>\n

Step 5:<\/h4>\n

Thus, our final bullet chart showing sales and profit values for each electronics sub-category or brand is ready. When you hover over any of the individual bars, you will get more information regarding it such as sub-category name, total profit value for the sub-category and total sales for the sub-category.\"bullet<\/a><\/p>\n

Summary<\/h3>\n

This concludes our tutorial on bullet chart in Tableau. Here, we learned how to create a bullet chart in a step-by-step process and saw what is a bullet chart.<\/p>\n

Don’t Waste time!! Scrabble the insights of your data with Tableau Bubble<\/a>.<\/strong><\/em><\/p>\n

We hope our explanation on the tableau bullet chart proved helpful for you and enabled you to create bullet charts on your own. However, if you have any queries, mention them in the comment section. We will be happy to help you!

In this tutorial, we are going to learn about bullet chart in Tableau. The bullet charts are an advance type visualizations which provide detailed information on the dataset. Here, we are going to learn...<\/p>\n","protected":false},"author":5,"featured_media":73897,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[2227,21586,14180,14181,21478],"class_list":["post-9774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-bullet-chart-in-tableau","tag-create-bullet-chart","tag-tableau-bullet-chart","tag-tableau-bullet-graph","tag-what-is-bullet-chart"],"yoast_head":"\nBullet Chart in Tableau - Utilize your data to fullest with tableau bullet - DataFlair<\/title>\n<meta name=\"description\" content=\"Bullet Chart in Tableau - Learn the basics of bullet chart and the steps to create a tableau bullet chart for accommodating more detail of your data.\" \/>\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-bullet-graph\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bullet Chart in Tableau - Utilize your data to fullest with tableau bullet - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Bullet Chart in Tableau - Learn the basics of bullet chart and the steps to create a tableau bullet chart for accommodating more detail of your data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/\" \/>\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-05T01:08:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-28T12:02:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bullet Chart in Tableau - Utilize your data to fullest with tableau bullet - DataFlair","description":"Bullet Chart in Tableau - Learn the basics of bullet chart and the steps to create a tableau bullet chart for accommodating more detail of your data.","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-bullet-graph\/","og_locale":"en_US","og_type":"article","og_title":"Bullet Chart in Tableau - Utilize your data to fullest with tableau bullet - DataFlair","og_description":"Bullet Chart in Tableau - Learn the basics of bullet chart and the steps to create a tableau bullet chart for accommodating more detail of your data.","og_url":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-05T01:08:52+00:00","article_modified_time":"2025-02-28T12:02:29+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Bullet Chart in Tableau – Utilize your data to fullest with tableau bullet","datePublished":"2018-03-05T01:08:52+00:00","dateModified":"2025-02-28T12:02:29+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/"},"wordCount":821,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.jpg","keywords":["Bullet Chart in Tableau","create bullet chart","Tableau Bullet Chart","Tableau Bullet Graph","what is bullet chart"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/","url":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/","name":"Bullet Chart in Tableau - Utilize your data to fullest with tableau bullet - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.jpg","datePublished":"2018-03-05T01:08:52+00:00","dateModified":"2025-02-28T12:02:29+00:00","description":"Bullet Chart in Tableau - Learn the basics of bullet chart and the steps to create a tableau bullet chart for accommodating more detail of your data.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/tableau-bullet-chart.jpg","width":802,"height":420,"caption":"bullet chart in tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-bullet-graph\/#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":"Bullet Chart in Tableau – Utilize your data to fullest with tableau bullet"}]},{"@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\/9774","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=9774"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/9774\/revisions"}],"predecessor-version":[{"id":144321,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/9774\/revisions\/144321"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/73897"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=9774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=9774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=9774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}