View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

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