Rotating a whole chart

B

Brad

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
 
J

John Mansfield

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I a rotate my square radar chart (square->diamond)? 4
Chart SERIES OFFSET 5
Odd Chart Format Results 1
Rotating a chart, and more.. 2
Charting Beginning Revenue and Changes Over a 12 year period 1
Office 365 Outlook adding unwanted HTML to Email Body 0
Waterfall chart difficulties 2
Rotating a series of grouped shapes and text boxes. 1

Top