Excel Charts<\/strong> are one of the most widely used tools to visually present data. With everything that we do on it, changes can always be made and our charts can be improved.<\/p>\n\n\n\nIn the example below, we will show you how can you change the values and range in charts<\/strong>.<\/p>\n\n\n\nChange the Axis Values<\/h2>\n\n\n\n We will create two tables: one with the fruits sold from 2018 to 2020<\/strong>, and another one with sales results from three different stores<\/strong> in the same period:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will select the first table, and then go to Insert tab >> Charts >> Recommended Charts<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the window that appears, we will choose the first option- Clustered Column<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nAll we need to do is click OK<\/strong> and we will have our chart ready<\/strong>. Now, if we want to change the Axis value<\/strong>, we will click on the chart, then go to Chart Design, and choose Select Data<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the window that appears, we will click on Edit in Horizontal (Category) Axis Labels<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nAnd we will choose range A9:A11<\/strong> instead of A2:A5<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur chart will look like this now:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will repeat the same steps for yearly data, and change the Legend Entries (Series)<\/strong> by editing every year<\/strong>, and including the data from our second table (range B9:D11):<\/strong><\/p>\n\n\n\n <\/figure>\n\n\n\nLike this:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe do not have to change series names, as the years are the same in both tables. Our chart will finally make sense after all the changes:<\/p>\n\n\n\n <\/figure>\n\n\n\nAs seen, due to the changes in the range, our Axis Range<\/strong> that is shown on the left side is also changed<\/strong>, without us choosing to do so.<\/p>\n\n\n\nChange the Axis Range<\/h2>\n\n\n\n If we want to change the Axis Range<\/strong> without changing the axis values, we need to click on the Axis<\/strong> (located on the left side of our chart). When we do this, the Format Axis window<\/strong> will appear on the right side<\/strong> of our screen:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will expand Axis Options<\/strong> (in the screen above), and then choose the minimum and maximum Bounds<\/strong> for our chart:<\/p>\n\n\n\n <\/figure>\n\n\n\nThis is what the chart looks like after these changes:<\/p>\n\n\n\n <\/figure>\n\n\n\nDue to the changes, we lost our Chart name<\/strong>, and some of our bars reach the maximum, and we do not have a real presentation of data. We can easily reset the Bounds<\/strong> by clicking on the Reset button<\/strong> if we do not like what we did.<\/p>\n","protected":false},"excerpt":{"rendered":"Excel Charts are one of the most widely used tools to visually present data. With everything that we do on it, changes can…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Change the Axis Range in Excel Charts<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n