Creating Graph in 3D format

[vjharry]

Hi,

Could you please help me out to create 3D Graphs with below mentioned data in 5 Dimensions

Time Bubble X-axis Y-axis Bubble Size

Month Type ROR Net Exposure Business Level
Jan-14 A1 4.00% 100.00% 10.00
Jan-14 A2 4.00% 80.00% 50.00
Jan-14 A3 -1.50% 150.00% 45.50
Jan-14 A4 -6.00% 180.00% 60.00
Jan-14 A5 0.50% 150.00% 25.00
Jan-14 A6 1.85% 100.00% 23.00
Jan-14 A7 -2.50% 95.00% 3.00


Thanks in Advance
Vijay

[vjharry]

May i expect any reply on this

[MrShorty]

Without more detail regarding the specific chart you are looking for, I will simply suggest that you review this help file ( https://support.office.com/en-us/art...rs=en-US&ad=US ) which contains basic instruction from Microsoft for creating 3D surface charts. I will also include this page by Jon Peltier (http://peltiertech.com/contour-and-s...in-excel-2007/ ) with discussion around creating surface charts.

As with a lot of charting questions that I see here, the key part of your question may not be about creating the chart at all, but about how to rearrange your data in the spreadsheet into something that is conducive to the chart you are wanting to create. My first specific suggestion might be to look at the examples I've given and study how they have arranged their data before creating the chart, then work on arranging your data in a similar format.