I have a bar chart I am making in which one series of data
is much larger than the others (say 30,000 units versus
1,000 units). When I chart it I get one very long bar for
the 30,000 units and a buch of small bars for the other
series.
I'd like to "break" the y-axis scale so that the 30,000
unit series is still shown but is not out of line with the
others. It is a change in the graphical represnetation of
the data, but I've looked in Help but can't seem to find
this feature.
It is hard to describe in text, but I've seen it done
quite often in publication. Just not sure how to pull it
off in Excel.
Thanks
-Tyler
Andy Pope - 26 Jan 2004 14:55 GMT
Hi Tyler,
Take a look at Jon's example.
(http://peltiertech.com/Excel/Charts/BrokenYAxis.html)
which also includes links to examples on both Tushar Mehta's and my own
site.
> I have a bar chart I am making in which one series of data
> is much larger than the others (say 30,000 units versus
[quoted text clipped - 14 lines]
> Thanks
> -Tyler

Signature
Cheers
Andy
http://www.andypope.info
Frank Kabel - 26 Jan 2004 14:56 GMT
Hi Tyler
have a look at
http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/index.html
or
http://peltiertech.com/Excel/Charts/axes.html#Broken
HTH
Frank
> I have a bar chart I am making in which one series of data
> is much larger than the others (say 30,000 units versus
[quoted text clipped - 14 lines]
> Thanks
> -Tyler