Specifying Labels
To specify your own labels for a legend, access the Labels property of the Legend object and call its Add method. For example, the following code creates a set of three legend labels:
With Chart3D1.Legend.Labels
.Add "First"
.Add "Second"
.Add "Third"
End With