Making a bar chart "broken" for large data

  • Thread starter Thread starter Tyler
  • Start date Start date
T

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top