Thread: Broken lines in a chart to display extreme values?

Sometimes a single extreme value causes the rest of the data to become too
small, like a bar chart of the values (10000, 4, 3, 2, 4, 5). The way to
avoid is to use broken lines where the axis makes a leap from 10 to 9990 with
a dotted gap inbetween. I couldn't find a way to implement this in Excel. Is
there a way?

Hi,

It is not a built in option but can be constructed.
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Metin Örsel wrote:
> Sometimes a single extreme value causes the rest of the data to become too
> small, like a bar chart of the values (10000, 4, 3, 2, 4, 5). The way to
> avoid is to use broken lines where the axis makes a leap from 10 to 9990 with
> a dotted gap inbetween. I couldn't find a way to implement this in Excel. Is
> there a way?

--

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