headermask image

Business Tools Blog

Format a bar chart with negative values

I recently saw a disconnect Pareto chart that looked something like this:

Photobucket

The chart messy and it was very hard to read, because rhe customer names on the x axis overlap the bars.

To fix the problem, double click on the x axis.  Then select Tick mark labels = Low.

Photobucket

The customer names are now displayed at the bottom of the chart.

Photobucket

If you liked my post, feel free to subscribe to my rss feeds

2 Comments so far (Add 1 more)

  1. Great idea! thank you

    1. Sandi Mays on August 28th, 2008 at 7:19 am
  2. The labels are still hard to read, because they are not horizontal. This is a good time to use a horizontal bar chart rather than a vertical column chart.

    2. Jon Peltier on August 28th, 2008 at 3:44 am

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*