Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
In ,
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |