soarinjohn
New Member
- Joined
- Oct 3, 2008
- Messages
- 5
Hello. I am fairly handy in using Excel but I am stuck on a graph problem.
I am essentially trying to graph a US yield curve that has the following x axis year points: 0, .08, .25, .50, 1.0, 2.0, 5, 10.0, and 30.0. When I create the graph using values for the y axis, the x axis is uniformally scaled such that my 5 year point looks like it is 2/3rd the way down the curve instead of where it would be... .16 down the path on the x axis. How do I control (or scale) the x-axis so the points plot where I want them instead of uniformly being distributed as is the default case. I do not want to create "dummy" interpolated points to trick the x-axis based on all the different ways I will be shaping the curves I need to graph.
Thanks in advance for the help.
John
I am essentially trying to graph a US yield curve that has the following x axis year points: 0, .08, .25, .50, 1.0, 2.0, 5, 10.0, and 30.0. When I create the graph using values for the y axis, the x axis is uniformally scaled such that my 5 year point looks like it is 2/3rd the way down the curve instead of where it would be... .16 down the path on the x axis. How do I control (or scale) the x-axis so the points plot where I want them instead of uniformly being distributed as is the default case. I do not want to create "dummy" interpolated points to trick the x-axis based on all the different ways I will be shaping the curves I need to graph.
Thanks in advance for the help.
John