Rotating a whole chart
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 |
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 |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com