Controlling Radar and Surface Charts in Excel 2007:-

A couple minor settings affect surface charts and radar charts. A default surface chart uses contour shading within each color band in order to give a 3-D feeling. You can turn this off in a surface chart by using the Has3DShading property. In the Figure (given below), the bottom-left chart has the shading turned off.



[The bottom charts reflect removing the 3-D contour (left) and radar axis labels (right).]

Radar charts typically have the name of each category at the end of the axis. You can turn this off by setting the HasRadarAxisLabels property to False. The bottom-right chart in the above Figure shows this setting.

The code for turning off the Has3DShading and HasRadarAxisLabels properties follows:

Sub FormatSurface()

Dim chtg As ChartGroup

Set chtg = ActiveChart.ChartGroups(1)

chtg.Has3DShading = False

End Sub


Sub FormatRadar()

Dim chtg As ChartGroup

Set chtg = ActiveChart.ChartGroups(1)

chtg.HasRadarAxisLabels = False

End Sub