Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

Zach

unread,
Apr 23, 2006, 2:03:01 AM4/23/06
to
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

unread,
Apr 23, 2006, 8:03:53 AM4/23/06
to
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/newsgroups/broken_y_axis/tutorial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

--

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

0 new messages