PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?WmFjaA==?=
Guest
Posts: n/a
 
      23rd Apr 2006
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!
 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      23rd Apr 2006
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:03 AM.