View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default bar graph: how do you insert a break in scale (squigglly line)?

Hi,

Here are some examples of how to produce a broken axis effect.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Zach wrote:
With a wide data range or one number that is much larger than others in a
series, how can one insert a break in the scale, often represented by 2
squiggly lines?

Thanks!


--

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