[mso] Re: EXCEL Empty Circles in a Table

Hi Ray,
As a quick and dirty method you can use the drawing toolbar. First, format 
your table to get the cells the size you want; using Arial as the default 
font, the relationship to get a more-or-less square cell is, for example, 
for a column width of 12 a row height of about 60. Adjust column width and 
row height up or down in the same proportion to get the squares the size 
you want.
To draw a circle, click on the elipse on the drawing toolbar, then 
shift-click on the spreadsheet and, holding down the shift key, move the 
cursor to get a circle the size you want. Move this circle to inside one of 
the table cells and position it as nearly centered as you can. Right click 
on the circle outline and select "format autoshape" to change the line 
thickness, if not satisfactory.
Now copy the cell and paste it to the other table cells.
Wilson

At 19:43 26/6/2004, R Shapp wrote:
>Hi Group,
>
>I made an Excel table in which each cell contains an empty circle.  It is
>seven columns by four rows, and is used by my students for sketching the
>phases of the Moon during one complete lunar month.
>
>To obtain the circles, I used the octal 81 character in the Wingdings 2 set,
>then I used a very large font setting.  This gave me perfect circles, but
>their line width is very thick.  They look more like Cheerios rather than
>outlines of the Moon.
>
>Will someone tell me how to use the graphing tool or maybe some other method
>to populate a table with circles suitable for sketching?
>
>Thanks for the help.
>
>Ray Shapp


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: