View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default Rotating a whole chart

Assuming a 3D chart, a simple procedure could be:

Sub RotateChart()
With ActiveChart
.Elevation = 20
.Perspective = 15
.Rotation = 25
End With
End Sub

You could add a loop with a timer to automate showing different perspectives
at different intervals.

--
John Mansfield
cellmatrix.net


"Brad" wrote:

I believe one of the MVP contributors has published code to rotate a whole
chart from 0° to 360° so that it can be viewed from different perspectives.

Does this come to mind??? I thought I had it bookmarked, but...

My thanks in advance for any clues.

Cheers! Brad