3D graph (yield curve)


A

Arne Hegefors

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..
 
Ad

Advertisements

J

Jon Peltier

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
 
Ad

Advertisements

T

Todd Eve

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/lightweight-3d/ms-office-add-ins/excel-xyz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top