Lesson#98: How to customize axis of chart

So I have discussed about creating a chart and what type data are suitable for what type of chart. Now I am going about detail discussion about the features and options behind chart. These are very important when you need to format your chart. This post is about how to customize axis of chart.

Here I am having a chart made on the average temperature data for some cities. This is one of the simplest example of chart. At the right side of the chart you can see three buttons. First one is a ‘+’ sign and this is Chart Elements, second one is like brush and this is Chart Styles, third one is Chart Filters. We will go for the first one, Chart Elements.

Within the Chart Elements there are many options for modifying, 1. Axes, 2. Axis Titles, 3. Chart Titles, 4. Data Labels, 5. Data Table, 6. Error Bars, 7. Gridlines, 8. Legend, 9. Trendline.

In this post our concern is the 1st one, Axes.

When you hover mouse cursor on the Axes option, you will find three options, 1. Primary Horizontal, 2. Primary Vertical, 3. More Options. First two options for toggling on off mode for primary axes. It is easily done by ticking on the checkbox. In the above picture I have shown the position of these two axes. Clicking on the more options opens a window tab named Axis Options.

Here you can modify the Axis Type, Vertical Axis crosses and Axis position.

Like if you need to reverse the axis order then then go to Axis Option and then Axis Position and tick the checkbox Categories in reverse order.


From this Alignment option you can modify the alignment of the axis names.

So this a little discussion about how to customize axis of chart. Subscribe the blog and stay connected.

Puspendu is the founder author of Excelabcd. He is a creative person, blogger and Excel-maniac guy.

Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *