Hi,
I guess you could rotate a 3d surface plot.
'----------
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/07/2008 by Andy Pope
'
Dim lngLoop As Long
Dim lngDelay As Long
'
With ActiveSheet.ChartObjects("Chart 1").Chart
For lngLoop = 1 To 360
.Rotation = lngLoop
DoEvents
For lngDelay = 1 To 5000
'CRUDE DELAY
Next
Next
End With
End Sub
'-----------
My 3d scatter rotates by using formula to adjust the data values. Some
simple code would allow for continual rotation.
http://www.andypope.info/charts/3drotate.htm
Although not really charts my clocks workbook demonstrates how to animate
charts.
http://www.andypope.info/fun/clocks.htm
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jon Peltier" wrote in message
...
You rotated an Excel chart? An embedded chart object? Or a picture of a
chart?
What is the purpose of rotating the chart?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Matthew Wells" wrote in message
. ..
Any kind. I did this in school in '99. You iterate in a loop rotating
10 degrees at a time. I did it in VB (I'm assuming you could do it in
VBA as well). Does anyone know the code?
"Jon Peltier" wrote in message
...
I hope you're talking about a pie chart, because other types are not
intended to spin. In the pie chart, you have a property called Angle of
First Slice. To make the chart seem to spin, you need code that
increments this angle from zero to 360, then starts again at zero.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Matthew Wells" wrote in message
...
I know I've seen some code somewhere that made a chart spin
continuously. Does anyone know how to do this?
Thanks.
--
Matthew.Wells