|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
06-16-2005, 04:05 PM
|
|||
|
|||
|
Splitting the y-axis
Can I split the scale of the y-axis so that it jumps from a lower value to a
higher, e.g. value of 80 to 300 to account for a few large data points I have? This would be like putting a 'wiggle' in the axis. 
|
|
#2
06-16-2005, 08:05 PM
|
|||
|
|||
|
RE: Splitting the y-axis
Try this:
http://peltiertech.com/Excel/Charts/axes.html#Broken "mem" wrote: > Can I split the scale of the y-axis so that it jumps from a lower value to a > higher, e.g. value of 80 to 300 to account for a few large data points I > have? This would be like putting a 'wiggle' in the axis.
|
|
#3
06-16-2005, 09:05 PM
|
|||
|
|||
|
Re: Splitting the y-axis
I have an example on my web site:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html and so do Andy Pope and Tushar Mehta: http://andypope.info/charts/brokencolumn.htm http://tushar-mehta.com/excel/newsgr...xis/index.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ mem wrote: > Can I split the scale of the y-axis so that it jumps from a lower value to a > higher, e.g. value of 80 to 300 to account for a few large data points I > have? This would be like putting a 'wiggle' in the axis.
|
|
#4
06-17-2005, 04:05 AM
|
|||
|
|||
|
Re: Splitting the y-axis
In news:3146E1C6-9A04-462B-AB41-DAF130FDEEDE@microsoft.com,
mem scrive: > Can I split the scale of the y-axis so that it jumps from a lower value to a > higher, e.g. value of 80 to 300 to account for a few large data points I > have? This would be like putting a 'wiggle' in the axis. take a look: http://www.prodomosua.it/zips/taglio.xls .f
|
 |
| 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
