How can I make a chart like this in Excel (2010)2010?
Image from: http://www.epaEPA.gov/recovery/images/bar-chart.gif
I have data where 2two 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*)maximum†, but to add an arrow to the top. Or to let the bar fade out.
*) That's†That's what Excel 2010 does when specifying a maximum that is smaller than the largest value.