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?