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.
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.
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.