+ Reply to Thread
Results 1 to 3 of 3

copy and rotate

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    copy and rotate

    I am struggling to make a scale using SmartArt lines.
    What I would like to do is to draw an horizontal line and then copy this and paste it 9deg rotated and continue this till with 20 lines I have covered 180deg. Is this possible?
    John

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: copy and rotate

    Good afternoon j_southern

    Are you using SmarArt or the standard Insert > Shapes functionality. I don't think you can do it using the former, but you could using the latter though it's a but fiddly.

    • For 9 degrees of separation covering 180 degrees you will need 20 lines.
    • Create one line and copy it 19 times.
    • Right click on one line, and select Format Shape.
    • under the "Effects" box - the middle one, select the 3-D Rotation option.
    • Under the Z Rotation preset, set this to 9 degrees and move your line into place.
    • Do the same for all other lines, increasing the preset by 9 degrees at a time.

    HTH

    DominicB

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: copy and rotate

    DominicB,
    Many thanks for your response. I was using the smartart option in much the way you suggest. You are very right in saying its a bit fiddly! I was hoping I could say set out one 45deg section and group it and then copy and rotate this3 times. I could but because the copy does not appear exactly over the original it is impractical. I will just have to be patient.
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. rotate bar around circle
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 12:35 PM
  2. Rotate Text
    By Jane753 in forum Excel General
    Replies: 3
    Last Post: 07-14-2013, 09:09 AM
  3. Replies: 4
    Last Post: 05-07-2012, 08:09 PM
  4. Rotate a chart
    By cj1958 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-04-2010, 10:30 PM
  5. Rotate row
    By MattG in forum Excel General
    Replies: 3
    Last Post: 06-18-2006, 11:15 AM
  6. Rotate a text box?
    By PCLIVE in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-28-2005, 01:05 PM
  7. [SOLVED] Excel VBA Need to rotate players - find / copy last 3 rows and move to the top
    By sam s via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2005, 06:05 AM
  8. Rotate textbox
    By Pat in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 09:06 AM

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