Making a bar chart "broken" for large data

[Tyler]

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]

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
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

--

Cheers
Andy

http://www.andypope.info

 

[Frank Kabel]

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