XYZ graph?

[JenningsBeach]

I need to generate a 3-D graph of a matrix where values within the matrix depend on the top most row / and left most column. In other words, I need to extend the usual XY scatter plot to an XYZ version.

For example if the row are years ( 1,2,3,) and the columns are interest rates (0, 1% , 2%, 3%, 4%) and the data inside is accumulated value ( 1+i)^y, I would like to see a 3 x5 planar base with labels year and interest rate, with the values for each shown and there would a surface above it rising as high as the computed accumulation values in the cells. It should be easy, but I can't really get it to work.

Any help would be appreciated. Thanks!

[shg]

See http://office.microsoft.com/en-us/ex...001117939.aspx

[JenningsBeach]

Thanks again!

[surc6]

Excel doesn't have the capability to do 3D graphs. You can get a 2.5D graph as mentioned above, but then your depth is uniform and not an accurate visualization of your data. The best thing to do is go on a hunt for a good graphing program. One you might really like because it works in excel as an add-in program is: http://www.threedify.com/en/lightwei...-ins/excel-xyz