{"id":1281,"date":"2015-05-28T11:57:45","date_gmt":"2015-05-28T09:57:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1281"},"modified":"2024-04-14T15:00:18","modified_gmt":"2024-04-14T13:00:18","slug":"change-the-axis-units-in-an-excel-chart","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-the-axis-units-in-an-excel-chart\/","title":{"rendered":"Change the Axis Units in an Excel Chart"},"content":{"rendered":"<p>Whenever you create a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-axis-labels-in-excel\/\" target=\"_blank\" rel=\"noopener\">chart in Excel<\/a>, it gives you the default vertical Axis based on the values that are in your data set.<\/p>\n<p>If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in your chart.<\/p>\n<p>A great way to overcome this problem is to display the axis units in &#8220;Thousands&#8221; or &#8220;Millions&#8221;, thus making your chart much more cleaner.<\/p>\n<p>See how this is done below&#8230;<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/ORhneQUT2R8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline;color: #0000ff\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Axis-Units.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Axis-Units.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline\"><span style=\"color: #0000ff;text-decoration: underline\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><a href=\"http:\/\/www.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103_0_1_10\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Find Blank Cells In Excel With A Color\" class=\"alignnone wp-image-1152 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/04\/eu_logo_150.png\" alt=\"Find Blank Cells In Excel With A Color\" width=\"150\" height=\"150\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set. If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in your chart. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17401,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Change the Axis Units in an Excel Chart","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,73],"tags":[94,74],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1281"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1281"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1281\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17401"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}