{"id":9196,"date":"2022-03-07T18:57:49","date_gmt":"2022-03-07T18:57:49","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9196"},"modified":"2024-03-26T10:46:51","modified_gmt":"2024-03-26T10:46:51","slug":"change-the-axis-scale-in-an-excel-chart","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/","title":{"rendered":"Change the Axis Scale in an Excel Chart"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-e0e478c5-cca3-4448-a8cb-4c8b4ef96447\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Change-the-Axis-Scale-in-an-Excel-Chart.xlsx\">Change-the-Axis-Scale-in-an-Excel-Chart<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Change-the-Axis-Scale-in-an-Excel-Chart.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-e0e478c5-cca3-4448-a8cb-4c8b4ef96447\">Download File<\/a><\/div>\n\n\n\n<p>Excel&#8217;s charts are impressive, but some of the automated features in Excel may not be ideal for your specific needs. For this reason, you may want to modify some aspects of your graph manually.<\/p>\n\n\n\n<p>For example, suppose you want to change the scale that Excel uses along the axis of a chart as the default settings may not represent all the possibilities you want to show on your chart.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"example\">Example<\/h2>\n\n\n\n<p>This chart presents data from 0 to 18. The problem here is that there is no value smaller than 8, therefore almost half of the chart is empty. If this is your intention then you can leave it as is, otherwise, you can modify it by setting the minimum value and changing the scale.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"461\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\" alt=\"Chart, line chart\n\nDescription automatically generated\" class=\"wp-image-9198\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png 709w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2-300x195.png 300w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"setting-minimum-and-maximum-values\">Setting minimum and maximum values<\/h2>\n\n\n\n<p>Let&#8217;s change the scale by setting the minimum value to 6. It leaves some space between the line and the bottom edge of the <strong>Plot Area<\/strong>.<\/p>\n\n\n\n<p>Right-click <strong>y-axis<\/strong> values and click <strong>Format Axis<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"265\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-application-description-3.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-9199\"\/><\/figure>\n\n\n\n<p>Inside the <strong>Axis Options<\/strong> tab, set minimum bounds to 6 and major units to 1. Notice that this automatically changed maximum bounds to 17. You can change that back to 18 or keep the default value.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"315\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-description-automaticall-1.png\" alt=\"Graphical user interface\n\nDescription automatically generated\" class=\"wp-image-9200\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-description-automaticall-1.png 285w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-description-automaticall-1-271x300.png 271w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/figure>\n\n\n\n<p>The minimum bounds and major units have been changed, so let&#8217;s see what the chart looks like.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"418\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-3.png\" alt=\"Chart, line chart\n\nDescription automatically generated\" class=\"wp-image-9201\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-3.png 465w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-3-300x270.png 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"scaling-the-x-axis\">Scaling the x-axis<\/h2>\n\n\n\n<p>You can also scale values on the horizontal axis. Even though these are dates, not numbers, you can use the same methods to modify these values.<\/p>\n\n\n\n<p>If you think there are too many of them, you can right-click the x-axis and then <strong>Format Axis<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"284\" height=\"461\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-application-description-4.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-9202\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-application-description-4.png 284w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-application-description-4-185x300.png 185w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/figure>\n\n\n\n<p>By changing the major units to 3, now every 3rd month is displayed on the chart.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"418\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-4.png\" alt=\"Chart, line chart\n\nDescription automatically generated\" class=\"wp-image-9203\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-4.png 465w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-4-300x270.png 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/figure>\n\n\n\n<p>You can also scale months to years, therefore only two values on the x-axis are going to be displayed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;s charts are impressive, but some of the automated features in Excel may not be ideal for your specific needs. For this reason,&#8230;<\/p>\n","protected":false},"author":1,"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>Change the Axis Scale in an Excel Chart<\/title>\n<meta name=\"description\" content=\"Learn how to modify the scale of your Excel chart manually by setting minimum &amp; maximum values.\" \/>\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\/change-the-axis-scale-in-an-excel-chart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change the Axis Scale in an Excel Chart\" \/>\n<meta property=\"og:description\" content=\"Learn how to modify the scale of your Excel chart manually by setting minimum &amp; maximum values.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-07T18:57:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T10:46:51+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Change the Axis Scale in an Excel Chart\",\"datePublished\":\"2022-03-07T18:57:49+00:00\",\"dateModified\":\"2024-03-26T10:46:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\"},\"wordCount\":302,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\",\"name\":\"Change the Axis Scale in an Excel Chart\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\",\"datePublished\":\"2022-03-07T18:57:49+00:00\",\"dateModified\":\"2024-03-26T10:46:51+00:00\",\"description\":\"Learn how to modify the scale of your Excel chart manually by setting minimum & maximum values.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change the Axis Scale in an 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.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change the Axis Scale in an Excel Chart","description":"Learn how to modify the scale of your Excel chart manually by setting minimum & maximum values.","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\/change-the-axis-scale-in-an-excel-chart\/","og_locale":"en_US","og_type":"article","og_title":"Change the Axis Scale in an Excel Chart","og_description":"Learn how to modify the scale of your Excel chart manually by setting minimum & maximum values.","og_url":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/","article_published_time":"2022-03-07T18:57:49+00:00","article_modified_time":"2024-03-26T10:46:51+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Change the Axis Scale in an Excel Chart","datePublished":"2022-03-07T18:57:49+00:00","dateModified":"2024-03-26T10:46:51+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/"},"wordCount":302,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/","url":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/","name":"Change the Axis Scale in an Excel Chart","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png","datePublished":"2022-03-07T18:57:49+00:00","dateModified":"2024-03-26T10:46:51+00:00","description":"Learn how to modify the scale of your Excel chart manually by setting minimum & maximum values.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/chart-line-chart-description-automatically-gener-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/change-the-axis-scale-in-an-excel-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Change the Axis Scale in an 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."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9196"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=9196"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9196\/revisions"}],"predecessor-version":[{"id":15333,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9196\/revisions\/15333"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}