<\/figure>\n\n\n\nTo create a simple chart, we will select our data, then go to Insert >> Charts >> Recommended Charts<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOnce there, we will select Clustered Bar Chart<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur chart now looks the same as in the preview above:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe just changed the title to be \u201cGrades of the students\u201d<\/strong>.<\/p>\n\n\n\nWhat we want to achieve now is to make the grades descriptive, in the following order: Not good for 1, OK for 2, Good for 3, Very good for 4, and Excellent for 5.<\/strong><\/p>\n\n\n\nFirst, we will click on the numbers that we have on the X-axis and bind them to the number five<\/strong> since that is our maximum grade:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow we have the tougher part. We first need to create a new X and Y axis<\/strong>, that will be added to the existing chart. The X-axis<\/strong> will have numbers from 1 to 5<\/strong> and Y will have five zeroes<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will first add our X-axis<\/strong> by selecting the range J2:J6<\/strong>, then clicking on CTRL + C<\/strong> to copy it, then click on our chart and click CTRL+P<\/strong> to paste our selection. Our chart will have new series added now:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe can see that we have new series (Series 4)<\/strong>. We will click on our chart, go to Chart Design tab >> Type >> Change Chart Type<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will then choose the last option possible (Combo)<\/strong> and select XY scatter<\/strong> as an option for Series 4<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur chart looks like this right now:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe see the little yellow dots added to the chart. For the next step, we need to change the source data for our Series 4 <\/strong>to be all zeroes<\/strong>. To do so, we will choose the options we have beneath the \u201cNew Y-axis\u201d<\/strong>. The easiest way to do so is to click on the Chart<\/strong>, go to Format tab >> Current Selection<\/strong>, and then choose Series 4<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will then simply move the series to be equal range K2:K6<\/strong> instead of range J2:J6<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur chart now looks like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow our data points are all equal and all on the X-axis<\/strong>. We will select them, right-click on them and then click on Add data labels<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will then edit every data label by clicking on it, going to the Formula bar<\/strong>, and then hitting the \u201c=\u201d sign<\/strong>. We will add five grades, as follows: Not good for 1, OK for 2, Good for 3, Very good for 4, and Excellent for 5<\/strong>. This is our chart now:<\/p>\n\n\n\n <\/figure>\n\n\n\nWhat we can do now to make this prettier is to hide our X-axis<\/strong>. We will do it by clicking on the series (yellow dots), and formatting the color of this series to be completely white, which will make it invisible.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will move our marks a little bit, and finally, have our chart all ready and set:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"It is common knowledge that Excel is a great tool for presenting data. When we say that, we do not only mean numerical…<\/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
Show Labels Instead of Numbers on the X-axis in the Excel Chart<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n