Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet?
Dear Sir,
I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet?
Right click the shape, Format autoshape - colours & Lines and set
transparency to 100%. Hope this helps. Mike "Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet?
double click on the oval and select no fill for the fill options
"Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet?
Mr. Low
Set transparency to 100%. I like this macro. Allows for multiple selections. Sub My_Circle() Dim x, y As Single, area As Range 'rotate through areas - this allows multiple circles to be drawn For Each area In Selection.Areas With area ' x and y are numbers that are a function of the ' area's height and width x = .Height * 0.2 y = .Width * 0.2 ActiveSheet.Ovals.Add Top:=.Top - x, Left:=.Left - y, _ Height:=.Height + 2 * x, Width:=.Width + 2 * y ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _ .Interior.ColorIndex = xlNone End With Next area End Sub Gord Dibben MS Excel MVP On Fri, 27 Apr 2007 06:12:00 -0700, Mr. Low wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
Hello BJ,
Thanks, It works Low -- A36B58K641 "bj" wrote: double click on the oval and select no fill for the fill options "Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
Hello Mike,
Thanks, I have got it. Low -- A36B58K641 "Mike H" wrote: Right click the shape, Format autoshape - colours & Lines and set transparency to 100%. Hope this helps. Mike "Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
Helo Gord, Thanks, It works Low -- A36B58K641 "Gord Dibben" wrote: Mr. Low Set transparency to 100%. I like this macro. Allows for multiple selections. Sub My_Circle() Dim x, y As Single, area As Range 'rotate through areas - this allows multiple circles to be drawn For Each area In Selection.Areas With area ' x and y are numbers that are a function of the ' area's height and width x = .Height * 0.2 y = .Width * 0.2 ActiveSheet.Ovals.Add Top:=.Top - x, Left:=.Left - y, _ Height:=.Height + 2 * x, Width:=.Width + 2 * y ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _ .Interior.ColorIndex = xlNone End With Next area End Sub Gord Dibben MS Excel MVP On Fri, 27 Apr 2007 06:12:00 -0700, Mr. Low wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
Hello Gord,
Thanks, it works. Low -- A36B58K641 "Gord Dibben" wrote: Mr. Low Set transparency to 100%. I like this macro. Allows for multiple selections. Sub My_Circle() Dim x, y As Single, area As Range 'rotate through areas - this allows multiple circles to be drawn For Each area In Selection.Areas With area ' x and y are numbers that are a function of the ' area's height and width x = .Height * 0.2 y = .Width * 0.2 ActiveSheet.Ovals.Add Top:=.Top - x, Left:=.Left - y, _ Height:=.Height + 2 * x, Width:=.Width + 2 * y ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _ .Interior.ColorIndex = xlNone End With Next area End Sub Gord Dibben MS Excel MVP On Fri, 27 Apr 2007 06:12:00 -0700, Mr. Low wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
Can I jump in here with a related question?
Is there anyway to change the autoshape properties to default with transparent ovals rather than having to change then after they are drawn? "Mike H" wrote: Right click the shape, Format autoshape - colours & Lines and set transparency to 100%. Hope this helps. Mike "Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to draw an oval shape outline to the worksheet
No.
You could use VBA to insert transparent ovals where you wish. Here is sample code for drawing a transparent ellipse around a selection or multiple selections of cells. Sub My_Circle() Dim X, y As Single, area As Range 'rotate through areas - this allows multiple circles to be drawn For Each area In Selection.Areas With area ' x and y are numbers that are a function of the ' area's height and width X = .Height * 0.2 y = .Width * 0.2 ActiveSheet.Ovals.Add Top:=.Top - X, Left:=.Left - y, _ Height:=.Height + 2 * X, Width:=.Width + 2 * y ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _ .Interior.ColorIndex = xlNone End With Next area End Sub Gord Dibben MS Excel MVP On Sun, 21 Sep 2008 18:22:17 -0700, kennected wrote: Can I jump in here with a related question? Is there anyway to change the autoshape properties to default with transparent ovals rather than having to change then after they are drawn? "Mike H" wrote: Right click the shape, Format autoshape - colours & Lines and set transparency to 100%. Hope this helps. Mike "Mr. Low" wrote: Dear Sir, I need to draw an oval shape to circle up a group of figures in the worksheet for explanation purpose. However when I use the drawing tool at the drawing tool bar, the oval shape I have on the spreadsheet always superimposed on the figures. Another words the oval shape is filled and I cannot read anything that is circled. May I know how to get only the oval shape outline only? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel worksheet tabs to be organized vertically in outline format | Excel Worksheet Functions | |||
How can you draw a shape when the values change each time?? | New Users to Excel | |||
how can I draw a box and whisker plot in excel 2002? | Charts and Charting in Excel | |||
how to protect excel worksheet and still use the outline buttons? | Excel Worksheet Functions | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions |