How can I make a bar chart w/ one broken bar? One data point is
significantlylarger than the others. Showing the full scale on the Y axis
makes the other data points hard to read. Using a log scale allows all data
points to be read, but disquises the significance of the differences between
them. I'd like to use a linear scale and show a bar w/ a break in it to
represent the really large data point. Is this possible in Excel?
--
Jay

Hi,

You can find an explanation, with links to others, here
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Jay wrote:
How can I make a bar chart w/ one broken bar? One data point is
significantlylarger than the others. Showing the full scale on the Y axis
makes the other data points hard to read. Using a log scale allows all data
points to be read, but disquises the significance of the differences between
them. I'd like to use a linear scale and show a bar w/ a break in it to
represent the really large data point. Is this possible in Excel?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info