|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
05-26-2005, 06:15 PM
|
|||
|
|||
|
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? 
|
|
#2
05-26-2005, 06:15 PM
|
|||
|
|||
|
Re: How do i break really long bars to show short ones in Excel?
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
|
|
#3
05-26-2005, 06:15 PM
|
|||
|
|||
|
RE: How do i break really long bars to show short ones in Excel?
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?
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
