View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
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..