You need the code to rotate the chart, right? Can you do it manually? If so
(and I'm sure it's so), turn on the macro recorder while you rotate the
chart. Rotate the chart, approve the rotation and clear the dialog, then
repeat a couple times, while the recorder is running. Then see what the
recorded code uses to rotate the chart, and implement this into your
procedure.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Matthew Wells" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Let me start over. This is only for a "wow" effect. Obviously you can
> manually rotate any 3d graph by grabbing the handle and moving it. What I
> want is code that overall will take an access query result of maybe 5
> rows, 3 cols, create an Excel workbook, open it up, paste the query
> results in a worksheet, create a 3d graph, and then in VBA start a loop
> that will call the rotate method of the graph to give it the effect. Like
> I said, I've done this before back in school with vb6 in not too much
> code. I can do most of this already, I only need the rotating loop.
>
> Does anyone know this?
>
> Thanks.
>
>
> "Andy Pope" <(E-Mail Removed)> wrote in message
> news:BE32B61F-416B-4B99-9645-(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>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" <(E-Mail Removed)> wrote in message
>>>>> news:Y92dnQm8orNG1-(E-Mail Removed)...
>>>>>>I know I've seen some code somewhere that made a chart spin
>>>>>>continuously. Does anyone know how to do this?
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> --
>>>>>> Matthew.Wells
>>>>>> (E-Mail Removed)
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>
>
Similar Threads
