Show Horizontal Axis Entries Below the Chart

Great for displaying negatives in a line or column chart

I learned about a chart Axis option in Excel during a recent webinar – thanks to one of the attendees. You can show the Axis entries below the chart – this is handy for column charts that display negatives.

I will use a variance chart example from a previous blog post – see the before (top) and after (bottom) images below.


Depending on your Excel version the instructions are slightly different – see below.

Excel 2010

Right click the Axis and choose Format Axis. In the middle section of the Axis options, on the right hand side, click the Axis labels drop down and select Low. Click Close.


Excel 2013

Right click the Axis and choose Format Axis. Open the Labels section in the Task pane on the right. Click the Label Position drop down and select Low.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.