Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to Draw a half Circle in Excel (2003)

    Hi there, someone has come to me this morning wondering how to draw a half circle in Excel. I can't seem to get a nice straight one with the lines and curves, I can get a whole one and block off half, but realized I have never had to draw a half circle. They say they want to draw them in different sizes on their sheet.

    Any one know how to do this simply?

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to Draw a half Circle in Excel (2003)

    The following works best if you turn on Drawing > Align > To Grid from the Drawing toolbar.
    There is an Arc tool in the Basic Shapes panel (from AutoShapes on the Drawing toolbar).
    If you hold down Shift while drawing an arc, you get a perfect quarter circle.
    Next, hold down Ctrl while you drag the quarter circle, this duplicates it.
    Use Drawing | Rotate or Flip | Flip Horizontal to mirror the copy.
    Align the two quarter circles carefully, then select them both.
    Select Drawing > Group. The two quarter circles merge into a half circle.
    You can resize and rotate it.

  3. #3
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to Draw a half Circle in Excel (2003)

    Perfect! Thanks. The snap to grid part was what I was missing!

Posting Permissions

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