Formatting Shadow Settings in Excel 2007:-


A shadow is composed of a color, a transparency, and the number of points by which the shadow should be offset from the object. If you increase the number of points, it appears that the object is farther from the surface of the chart. The horizontal offset is known as OffsetX, and the vertical offset is known as OffsetY.

The following macro adds a light blue shadow to the box surrounding a legend:

Sub FormatShadow()

Dim cht As Chart

Set cht = ActiveChart

With cht.Legend.Format.Shadow

.ForeColor.RGB = RGB(0, 0, 128)

.OffsetX = 5

.OffsetY = -3

.Transparency = 0.5

.Visible = True

End With

End Sub