How do i break really long bars to show short ones in Excel?
 

In Excel, I'm trying to graph vertical bar graphs. One of my data values is
very large (several orders of magnitude larger) and the rest of my data
values are smaller. As a result, the small data values cannot be seen. My
question is how do I break the large value so that the small bars are visible?

Hi,

Here are some examples of how to put a break in the y axis.
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy


nkchu83 wrote:
In Excel, I'm trying to graph vertical bar graphs. One of my data values is
very large (several orders of magnitude larger) and the rest of my data
values are smaller. As a result, the small data values cannot be seen. My
question is how do I break the large value so that the small bars are visible?

--

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

Try this:

http://www.peltiertech.com/Excel/Cha...es.html#Broken

"nkchu83" wrote:

In Excel, I'm trying to graph vertical bar graphs. One of my data values is
very large (several orders of magnitude larger) and the rest of my data
values are smaller. As a result, the small data values cannot be seen. My
question is how do I break the large value so that the small bars are visible?