{"id":20212,"date":"2022-12-05T07:31:00","date_gmt":"2022-12-05T06:31:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=20212"},"modified":"2023-01-02T13:54:44","modified_gmt":"2023-01-02T12:54:44","slug":"speedometer-chart-with-excel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/","title":{"rendered":"Speedometer chart with Excel also called gauge chart"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-tutorial-to-create-a-speedometer-chart-with-excel-step-by-step\"><strong><em>Tutorial to create a speedometer chart with Excel step by step. <\/em><\/strong><\/h4>\n\n\n\n<p>Build a speedometer chart in Excel with this step by step guide. Graphs are a strong point of Excel, they allow to gauge and therefore analyse performance graphically. Here is an Excel tutorial to create a simple tachymeter graph. To start, create a doughnut chart with only one data series.<\/p>\n\n\n\n<p>First, for a gauge graph with eight zones, the doughnut chart in Excel must contain nine, one of which is equal to the sum of the other eight.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#1-create-the-zones-of-the-speedometer-chart\" >1. Create the zones of the speedometer chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#2-hide-the-left-part-of-the-gauge-chart\" >2. Hide the left part of the gauge chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#3-rotate-the-speedometer-graph\" >3. Rotate the speedometer graph<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#4-add-the-needle-to-the-doughnut-chart\" >4. Add the needle to the doughnut chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#5-make-only-the-needle-of-the-graph-visible\" >5. Make only the needle of the graph visible<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#6-overlap-the-graphs-and-adjust-the-gauge-chart-layout\" >6. Overlap the graphs and adjust the gauge chart layout<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#use-excel-speedometer-charts-carefully\" >Use Excel speedometer charts carefully<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-create-the-zones-of-the-speedometer-chart\"><\/span>1. Create the zones of the speedometer chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this tutorial, there are 4 zones, 3 plus 1 zone equivalent to the first 3 useful zones. These zones are simply created by a series of numbers, with the last one again equal to the first three.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>33<\/li>\n\n\n\n<li>33<\/li>\n\n\n\n<li>33<\/li>\n\n\n\n<li>99<\/li>\n<\/ul>\n\n\n\n<p>To do this, create a list or table with the above 4 values, and simply follow the four steps below.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><em>Select the 4 values<\/em><\/strong> equivalent to the zones of the ring.<\/li>\n\n\n\n<li>Select the <strong><em>Insert<\/em><\/strong> menu.<\/li>\n\n\n\n<li>Choose the icon with the <strong><em>pie charts<\/em><\/strong>.<\/li>\n\n\n\n<li>Finally, choose the <strong><em>Doughnut chart<\/em><\/strong> type.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"720\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-anneau.jpg\" alt=\"Add the doughnut chart with the values to build the Excel speedometer graph\" class=\"wp-image-17971\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-anneau.jpg 780w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-anneau-300x277.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-anneau-768x709.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\">Add the doughnut chart with the values to build the Excel speedometer graph<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-hide-the-left-part-of-the-gauge-chart\"><\/span>2. Hide the left part of the gauge chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Then, still in the <strong><em>Insert<\/em><\/strong> menu, click the <strong><em>Format Data Point<\/em><\/strong> button after selecting the Excel chart. From the Fill tab, select <strong><em>No Fill<\/em><\/strong> to make the largest zone of the Excel chart invisible, above and to the left.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"391\" height=\"537\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-03.jpg\" alt=\"Option to make half of the speedometer Excel chart invisible\" class=\"wp-image-4243\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-03.jpg 391w, https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-03-218x300.jpg 218w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><figcaption class=\"wp-element-caption\">Option to make half of the speedometer Excel chart invisible<\/figcaption><\/figure><\/div>\n\n\n<p>Once applied, only the left half of the pie chart is visible.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"228\" height=\"354\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-02.jpg\" alt=\"Hide one half of the Excel gauge chart\" class=\"wp-image-4241\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-02.jpg 228w, https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-02-193x300.jpg 193w\" sizes=\"auto, (max-width: 228px) 100vw, 228px\" \/><figcaption class=\"wp-element-caption\">Hide one half of the Excel gauge chart<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-rotate-the-speedometer-graph\"><\/span>3. Rotate the speedometer graph<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the <strong><em>Series Options<\/em><\/strong> tab, adjust the rotation cursor option, called <strong><em>Angle of first slice<\/em><\/strong>, so that this zone is at the bottom. And place the line to separate the two parts of the Excel chart so that it is perfectly horizontal. Either with an angle of <strong><em>270 degrees<\/em><\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"353\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-04.jpg\" alt=\"Adjust the rotation cursor to 270 degrees using the Angle of first slice option\" class=\"wp-image-4245\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-04.jpg 732w, https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-04-300x145.jpg 300w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><figcaption class=\"wp-element-caption\">Adjust the rotation cursor to 270 degrees using the Angle of first slice option<\/figcaption><\/figure><\/div>\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"EMpQiTxMJg\"><a href=\"https:\/\/expert-only.com\/en\/excel\/create-excel-pivot-table\/\">Create an Excel pivot table<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Create an Excel pivot table&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/excel\/create-excel-pivot-table\/embed\/#?secret=TQ0pzFKOU1#?secret=EMpQiTxMJg\" data-secret=\"EMpQiTxMJg\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-add-the-needle-to-the-doughnut-chart\"><\/span>4. Add the needle to the doughnut chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now create the needle of the tachymeter chart. It&#8217;s simple, just create an Excel pie chart with 4 zones.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The position of the needle on the chart, which is 80.<\/li>\n\n\n\n<li>The thickness of the needle, here it is 2.<\/li>\n\n\n\n<li>The third value is 100 minus the sum of the first two values.<\/li>\n\n\n\n<li>The fourth will be equal to 100.<\/li>\n<\/ol>\n\n\n\n<p>For the third value, I used an Excel formula and is it equal to 100 &#8211; 80 + 2  = 18<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"700\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-aiguille-1.jpg\" alt=\"Add the needle to the speedometer graph from the area with the 4 values\" class=\"wp-image-18003\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-aiguille-1.jpg 740w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/graphique-tachymetre-excel-00-creer-aiguille-1-300x284.jpg 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><figcaption class=\"wp-element-caption\">Add the needle to the speedometer graph from the area with the 4 values<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-make-only-the-needle-of-the-graph-visible\"><\/span>5. Make only the needle of the graph visible<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To make only the needle of the chart visible, select the graph and then click the Format Data Point button in the Data group under the Design tab. From the Fill tab, select No Fill to make the largest zone of the Excel chart invisible, above and to the left.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-overlap-the-graphs-and-adjust-the-gauge-chart-layout\"><\/span>6. Overlap the graphs and adjust the gauge chart layout<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, to finalize this tachymeter graph with Excel, overlap the two graphs like this. To move the needle, change its value from the source table. If desired, you can also add data labels and a title to the chart to show the current value and label the axis.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"287\" height=\"150\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2013\/05\/graphique-tachymetre-excel-07.jpg\" alt=\"Final result of the tachometer chart with a ring and a needle\" class=\"wp-image-4251\"\/><figcaption class=\"wp-element-caption\">Final result of the tachometer chart with a ring and a needle<\/figcaption><\/figure><\/div>\n\n\n<p>To save the speedometer chart as a separate image, click the <em>Export<\/em> button in the <em>Chart Tools<\/em> group under the <em>Design<\/em> tab, then choose <em>Save as Image<\/em>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"use-excel-speedometer-charts-carefully\"><\/span>Use Excel speedometer charts carefully<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In conclusion, the Excel  <a href=\"https:\/\/wikidiff.com\/tachymeter\/speedometer\" target=\"_blank\" rel=\"noreferrer noopener\">speedometer<\/a> chart, also known as a tachometer chart, can be a useful tool for visually displaying data in relation to a predefined scale or gauge. However, it is important to keep in mind that this type of chart may not always be the best choice for data visualization. One potential issue with speedometer charts is that they can be difficult to read accurately, especially when there are multiple data points or a wide range of values.<\/p>\n\n\n\n<p>It can also be challenging to compare data across different speedometer charts, as the scale and gauge may vary. In addition, Excel speedometer charts can take up a lot of space, which can make them impractical for use in certain situations.<\/p>\n\n\n\n<p>To go further and learn more about the possibilities of the Excel software, learn how to <a href=\"https:\/\/expert-only.com\/en\/excel\/pivot-excel-table\/\">pivot Excel data from lines into columns<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"rU7OGXBqUK\"><a href=\"https:\/\/expert-only.com\/en\/excel\/pivot-excel-table\/\">Pivot Excel table rows into columns<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Pivot Excel table rows into columns&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/excel\/pivot-excel-table\/embed\/#?secret=sDJuGUKrPL#?secret=rU7OGXBqUK\" data-secret=\"rU7OGXBqUK\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutorial to create a speedometer chart with Excel step by step. Build a speedometer chart in Excel with this step by step guide. Graphs are a strong point of Excel, they allow to gauge and therefore analyse performance graphically. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\" title=\"Speedometer chart with Excel also called gauge chart\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10709,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[],"class_list":{"0":"post-20212","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Speedometer chart with Excel - Excel Tips - MS Office<\/title>\n<meta name=\"description\" content=\"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Speedometer chart with Excel also called gauge chart\" \/>\n<meta property=\"og:description\" content=\"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-05T06:31:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-02T12:54:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Speedometer chart with Excel also called gauge chart\",\"datePublished\":\"2022-12-05T06:31:00+00:00\",\"dateModified\":\"2023-01-02T12:54:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\"},\"wordCount\":744,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\",\"url\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\",\"name\":\"Speedometer chart with Excel - Excel Tips - MS Office\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg\",\"datePublished\":\"2022-12-05T06:31:00+00:00\",\"dateModified\":\"2023-01-02T12:54:44+00:00\",\"description\":\"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Speedometer chart with Excel also called gauge chart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Speedometer chart with Excel - Excel Tips - MS Office","description":"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.","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:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/","og_locale":"en_US","og_type":"article","og_title":"Speedometer chart with Excel also called gauge chart","og_description":"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.","og_url":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-12-05T06:31:00+00:00","article_modified_time":"2023-01-02T12:54:44+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Speedometer chart with Excel also called gauge chart","datePublished":"2022-12-05T06:31:00+00:00","dateModified":"2023-01-02T12:54:44+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/"},"wordCount":744,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg","articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/","url":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/","name":"Speedometer chart with Excel - Excel Tips - MS Office","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg","datePublished":"2022-12-05T06:31:00+00:00","dateModified":"2023-01-02T12:54:44+00:00","description":"Tutorial on how to create a speedometer chart with Excel, in ring with a needle to represent data, called Excel jauge chart.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/journal-and-coffee-7BF9C361150_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/excel\/speedometer-chart-with-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Speedometer chart with Excel also called gauge chart"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/20212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=20212"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/20212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10709"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=20212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=20212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=20212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}