How can I make a chart like this in Excel 2010?
Image from: EPA.gov
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.