software

I often need to graph two parameters on the same bar graph whose high
values differ by a great deal - sometimes by a factor of 10 or 20 -
which makes the lower values almost disappear. I could use a second y
axis but sometimes it's inconvenient to do so. I have seen charts in
scientific journals that quot;breakquot; the y-axis to indicate that the scale
has been compressed and partially hidden. Is this possible in Excel?
It would really come in handy sometimes.
Mike--
burnsbyrne------------------------------------------------------------------------
burnsbyrne's Profile: www.excelforum.com/member.php...oamp;userid=22153
View this thread: www.excelforum.com/showthread...hreadid=536427Hi,

Not a builtin feature but here are some examples of how to produce a
broken axis effect.

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

Cheers
Andy

burnsbyrne wrote:
gt; I often need to graph two parameters on the same bar graph whose high
gt; values differ by a great deal - sometimes by a factor of 10 or 20 -
gt; which makes the lower values almost disappear. I could use a second y
gt; axis but sometimes it's inconvenient to do so. I have seen charts in
gt; scientific journals that quot;breakquot; the y-axis to indicate that the scale
gt; has been compressed and partially hidden. Is this possible in Excel?
gt; It would really come in handy sometimes.
gt; Mike
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info