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.

Horizontal bullet chart in Excel

Excel Yourself article

Check out my follow up article and VIDEO on the ITBDigital website on how to convert a vertical bullet chart into a horizontal one.

Click here for full article and video.

For the original bullet chart post click here

These techniques are based on ones in the great book
Excel 2007 Dashboards and Reports For Dummies by Michael Alexander

Excel Bullet Charts [Video]

Excel Yourself Article

Check out my July 2014 article on Bullet charts on the CPA Australia ITBDigital website – click here to see the article. The video is below.

Bullet charts were developed by Stephen Few – see his pdf on bullet charts click here.

The technique is based on one used by Michael Alexander in his great book Excel 2007 Dashboards and Reports for Dummies by Wiley.