Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Varying axis scaling
I'm trying to do a some pump curve graphs using a scatter plot. The problem is that there are both low end and high end curves that I'm trying to place on the same chart and the distances between the two are fairly large. What I want to do is have a varying scale for the x/y axis For example, for values x from 0 - 1000 a tick of 50 1000 - 4400 a tick of 200 y from 0 - 1000 a tick of 100 1000 - 2000 a tick of 200 2000 - 15000 a tick of 1000 Is this possible? -- jeffnoll ------------------------------------------------------------------------ jeffnoll's Profile: http://www.excelforum.com/member.php...o&userid=20023 View this thread: http://www.excelforum.com/showthread...hreadid=346088 |
#2
|
|||
|
|||
try using secondary x and y axes. see Jon Peltier's and Tushar Mehta's
webpages.(not tested) jeffnoll wrote in message ... I'm trying to do a some pump curve graphs using a scatter plot. The problem is that there are both low end and high end curves that I'm trying to place on the same chart and the distances between the two are fairly large. What I want to do is have a varying scale for the x/y axis For example, for values x from 0 - 1000 a tick of 50 1000 - 4400 a tick of 200 y from 0 - 1000 a tick of 100 1000 - 2000 a tick of 200 2000 - 15000 a tick of 1000 Is this possible? -- jeffnoll ------------------------------------------------------------------------ jeffnoll's Profile: http://www.excelforum.com/member.php...o&userid=20023 View this thread: http://www.excelforum.com/showthread...hreadid=346088 |
#3
|
|||
|
|||
Jeff -
You could also try this approach: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ jeffnoll wrote: I'm trying to do a some pump curve graphs using a scatter plot. The problem is that there are both low end and high end curves that I'm trying to place on the same chart and the distances between the two are fairly large. What I want to do is have a varying scale for the x/y axis For example, for values x from 0 - 1000 a tick of 50 1000 - 4400 a tick of 200 y from 0 - 1000 a tick of 100 1000 - 2000 a tick of 200 2000 - 15000 a tick of 1000 Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | 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 | |||
Y axis, need varying units | Charts and Charting in Excel |