bar graph: how do you insert a break in scale (squigglly line)?

's Computer Specifications

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!

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Scale on line graph	=?Utf-8?B?RWFzeVNpdGU=?=	Microsoft Excel Charting	1	18th Apr 2007 02:39 PM
Re: Changing Y Axis Scale with percentages (Line Graph)	Jon Peltier	Microsoft Excel Charting	0	21st Dec 2006 02:15 PM
How do I insert a break into a graph?	=?Utf-8?B?cnVubmVyZ2lybDAw?=	Microsoft Excel Charting	2	10th Nov 2006 05:03 AM
How do I split the axis scale on a line graph	=?Utf-8?B?RmlzaF9CaW9sb2dpc3Q=?=	Microsoft Excel Misc	2	24th May 2006 05:30 AM
How do you insert a scale break on the y-axis in Excel?	=?Utf-8?B?bGFrZWNoYXRlaQ==?=	Microsoft Excel Charting	1	29th Mar 2005 04:39 PM