Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
3D graph (yield curve)
Hi! I want to make a 3D graph showing the developement of the US treasury
curve over time. My data looks like this: In column A i have a list of dates. In column B I have the yield for the 1 year tenor corresponding to the date in A, in column C I have the yield for the 2 year tenor corresponding the date in A etc.Thus for each date I have many observations (one for each tenor). Now I want to make this into a 3d graph so you can see the yield curve for every date. Can someone please help me? I have tried but it seems that you can only use 3d graphs if you have a function.. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
3D graph (yield curve)
Why clutter things up with a 3D chart? It will be impossible to interpret.
I've seen yield curves plotted with data on X and yield on Y, with different lines for each term (i.e., one-year, two-year, etc.). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Arne Hegefors" wrote in message ... Hi! I want to make a 3D graph showing the developement of the US treasury curve over time. My data looks like this: In column A i have a list of dates. In column B I have the yield for the 1 year tenor corresponding to the date in A, in column C I have the yield for the 2 year tenor corresponding the date in A etc.Thus for each date I have many observations (one for each tenor). Now I want to make this into a 3d graph so you can see the yield curve for every date. Can someone please help me? I have tried but it seems that you can only use 3d graphs if you have a function.. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
3D graph (yield curve)
Excel doesn't have 3D charting capabilities. The only 3D chart they do have is their surface chart which is really only 2.5D. This wouldn't really work for you unless one of your axes were the same variables. To plot in 3D, you need an add-in. Try this one. I've been using it for about a year now, and it works really well. Also, its not very expensive. Its called grapher. http://www.threedify.com/fr/lightwei...-ins/excel-xyz
On Friday, May 02, 2008 3:20 AM ArneHegefor wrote: Hi! I want to make a 3D graph showing the developement of the US treasury curve over time. My data looks like this: In column A i have a list of dates. In column B I have the yield for the 1 year tenor corresponding to the date in A, in column C I have the yield for the 2 year tenor corresponding the date in A etc.Thus for each date I have many observations (one for each tenor). Now I want to make this into a 3d graph so you can see the yield curve for every date. Can someone please help me? I have tried but it seems that you can only use 3d graphs if you have a function.. On Friday, May 02, 2008 8:49 AM Jon Peltier wrote: Why clutter things up with a 3D chart? It will be impossible to interpret. I've seen yield curves plotted with data on X and yield on Y, with different lines for each term (i.e., one-year, two-year, etc.). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Arne Hegefors" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpolating Yield Curve | Excel Worksheet Functions | |||
area under the curve in a graph | Charts and Charting in Excel | |||
Bell Curve Graph | Charts and Charting in Excel | |||
overplot of curve and bar graph | New Users to Excel | |||
Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel |