Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I make a chart like this in Excel 2010?

bar chart with extrapolation

Image from:

I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a part of the Y axis (as shown in the chart above).

An alternative would be to limit the height of the values to the maximum†, but to add an arrow to the top. Or to let the bar fade out.

†That's what Excel 2010 does when specifying a maximum that is smaller than the largest value.

share|improve this question
up vote 5 down vote accepted

There's no function in Excel charting to do this, but Jon Peltier has a nice article on an alternative approach...

share|improve this answer
After reading this I feel stupid. It's so obvious how to let a bar fade out. Thanks! – Simon Dec 7 '11 at 20:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .