+ Reply to Thread
Results 1 to 2 of 2

Surface Plot Will Not Rotate

Hybrid View

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Surface Plot Will Not Rotate

    Trying to get my surface plot to rotate. Nothing happens. Any ideas from anyone?

    Sub Rotate()
    Dim spinner As Range
    Set spinner = Application.Range("spin")
        ActiveSheet.Shapes("Chart 5").ThreeD.Visible = True
        ActiveSheet.Shapes("Chart 5").ThreeD.RotationX = spinner.Value
    Calculate
    End Sub
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Surface Plot Will Not Rotate

    Changing the rotation of the chart will spin the plot area of a 3d surface plot

    ActiveSheet.Shapes("Chart 5").Rotation = spinner.Value
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1