|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 27th 07, 02:12 PM
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 
|
| Ads |
|
#2
April 27th 07, 02:14 PM
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
April 27th 07, 04:36 PM
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
April 27th 07, 08:28 PM
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
April 30th 07, 02:32 PM
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
April 30th 07, 02:32 PM
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
April 30th 07, 02:34 PM
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
April 30th 07, 02:34 PM
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
September 22nd 08, 02:22 AM
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
September 22nd 08, 09:06 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel worksheet tabs to be organized vertically in outline format | Ghomez32 | Excel Worksheet Functions | 0 | October 9th 06 06:44 PM |
| How can you draw a shape when the values change each time?? | man57 | New Users to Excel | 1 | April 17th 06 09:30 AM |
| how can I draw a box and whisker plot in excel 2002? | andywilson | Charts and Charting in Excel | 2 | March 28th 06 10:52 PM |
| how to protect excel worksheet and still use the outline buttons? | sylvia | Excel Worksheet Functions | 0 | December 6th 05 12:32 PM |
| can excel draw a shape based on values entered in cells | Milo | Excel Worksheet Functions | 1 | April 6th 05 01:36 AM |
Linear Mode
