Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 244
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interpolating Yield Curve [email protected] Excel Worksheet Functions 3 January 11th 08 12:52 PM
area under the curve in a graph Eduard Junior Charts and Charting in Excel 1 November 16th 07 04:21 AM
Bell Curve Graph GatorGirl Charts and Charting in Excel 2 March 24th 07 12:15 AM
overplot of curve and bar graph Bhaskre New Users to Excel 1 December 13th 06 03:35 PM
Have a formula yield a true blank that disconnects graph line Mr. Owl Charts and Charting in Excel 2 August 12th 06 01:31 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"