Controlling a Surface Chart Through 3-D Rotation in Excel 2007:-

You can spin a surface chart by rotating it. To access the rotation settings, you choose 3-D Rotation from the Layout ribbon. This takes you to the 3-D Rotation category of the Format Chart Area dialog, which has the following settings:

1. X Rotation—this setting ranges from 0 degrees to 359.9 degrees. It rotates the floor of the chart in a clockwise direction.

2. Y Rotation—this setting starts at +15 degrees. It is your viewing angle in relation to the baseline of the chart. With an angle of 15 degrees, you are looking slightly down at the chart. With an angle of 0 degrees, a lot of the 3-D effects disappear. As you increase from 10 to 80 degrees, you have slightly different views of the chart. At 90 degrees, the chart becomes flat, as you are looking directly down from above. You can also enter negative values from 0 to –90. As you move from –10 to –80, you look at the chart from underneath. This might allow you to see better detail. When you reach –90, the chart turns flat again, as you are looking directly up at the chart from below.

Perspective ranges from 0 to 120. A value of 0 creates the least distortion. As you increase to 120, the foreshortening increases, creating distortion similar to what you get with an ultra-wide-angle lens on a camera.