Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

Start with a hexagon and extend the sides.
--
Gary''s Student


"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

Gary's Student,

Apologies, I meant to post this in the Publisher forum, but now I'm
intrigued by your suggestion. I'll give it a go.

Cheers

Pete

"Gary''s Student" wrote:

Start with a hexagon and extend the sides.
--
Gary''s Student


"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

Two options below "basic shapes" is on called "Stars and Banners". There is
a five point star within this option.

"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

JR,

Thanks for this!

pete



"JR" wrote:

Two options below "basic shapes" is on called "Stars and Banners". There is
a five point star within this option.

"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

"Peter Rooney" wrote in message
...
Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle
(15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges
of
the two stars...and this is where the problem started. No matter how far
up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second
triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

One third of the way down from the apex is where the base of the other
triangle should cross.

Or you can build your star from 12 equilateral triangles. You can regard it
as 6 in the central hexagon and one on each face of the hexagon, or 9 small
triangles in each of your two big triangles, the overlap between the two
being the six in the hexagon.
Or you can find the centre of your first triangle, draw a circumscribed
circle, & then slide your second triangle to fit in the same circle.
--
David Biddulph

Hi,

I am not sure whether this answers your question. But you can make a six
pointed star as an Excel X,Y scatter plot as outlined below.

In say A2-A14, enter numbers 0, 30, 60, 90, ... 360. (These are angles in
degrees).
Enter the width (side of the star) in a helper cell, say E2.
Use the following formulas in B2, C2, and D2.
In B2, =A2*pi()/180 (This converts angles to radians)
In C2, =IF(MOD(A2,60)=0,$E$2*cos(B2),sqrt(3)*$E$2*cos(B2) )
In D2, =IF(MOD(A2,60)=0,$E$2*sin(B2),SQRT(3)*$E$2*sin(B2) )

Drag the formulas down the columns to row 16.

Make an XY Scatter plot of Column C versus Column D. Format the patterns
under Data Series to No marker, and Automatic Line.
You would have to resize the graph to an appropriate aspect ratio for
getting a good, symmetric-looking, star on the monitor or for printing out.

Columns C and D give you the x,y (or y,x) coordinates for the six inner and
six outer corner-points of the star; you can use those values if you were to
manually plot the shape on graph paper.

If you want to rotate the star by 60 degrees, switch the column ranges for
the axes.

Regards,
B. R. Ramachandran





"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

I will challenge anyone to follow that !
--
Big Rick


"B. R.Ramachandran" wrote:

Hi,

I am not sure whether this answers your question. But you can make a six
pointed star as an Excel X,Y scatter plot as outlined below.

In say A2-A14, enter numbers 0, 30, 60, 90, ... 360. (These are angles in
degrees).
Enter the width (side of the star) in a helper cell, say E2.
Use the following formulas in B2, C2, and D2.
In B2, =A2*pi()/180 (This converts angles to radians)
In C2, =IF(MOD(A2,60)=0,$E$2*cos(B2),sqrt(3)*$E$2*cos(B2) )
In D2, =IF(MOD(A2,60)=0,$E$2*sin(B2),SQRT(3)*$E$2*sin(B2) )

Drag the formulas down the columns to row 16.

Make an XY Scatter plot of Column C versus Column D. Format the patterns
under Data Series to No marker, and Automatic Line.
You would have to resize the graph to an appropriate aspect ratio for
getting a good, symmetric-looking, star on the monitor or for printing out.

Columns C and D give you the x,y (or y,x) coordinates for the six inner and
six outer corner-points of the star; you can use those values if you were to
manually plot the shape on graph paper.

If you want to rotate the star by 60 degrees, switch the column ranges for
the axes.

Regards,
B. R. Ramachandran





"Peter Rooney" wrote:

Good afternoon, fellow Publishers!

This is probably a real no brainer, but what I'm trying to do is create a
six pointed star using basic shapes. I created an equilateral triangle (15cm
wide by 12.99cm high - basic trig using sin(60) to work out the height,
copied it and flipped the copy upside down. I then aligned the left edges of
the two stars...and this is where the problem started. No matter how far up
or down I move one triangle in relation to the other, it just doesn't LOOK
right.

I need some sort of formula to say "given the height of the triangle, how
many cm down from the y origin of the first triange does the second triange
have to be?"

Unless of course someone can advise me as to how to get a six pointed star
from some other version of "basic shapes"

I use 2003 at work and 200 at home.

Thanks in advance

Pete

Big Rick Wrote:
I will challenge anyone to follow that !
--
Big Rick

OK.... see attached....

Pretty cool.


+-------------------------------------------------------------------+
|Filename: star.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3886 |
+-------------------------------------------------------------------+

--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473785

Sorry, this came up with an "invalid link" message!

Pete



"swatsp0p" wrote:


Big Rick Wrote:
I will challenge anyone to follow that !
--
Big Rick

OK.... see attached....

Pretty cool.


+-------------------------------------------------------------------+
|Filename: star.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3886 |
+-------------------------------------------------------------------+

--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473785

Nice one Bruce.

Peter, check the link:
http://www.excelforum.com/attachment...achmentid=3886

Mangesh




"swatsp0p" wrote in
message ...

Big Rick Wrote:
I will challenge anyone to follow that !
--
Big Rick

OK.... see attached....

Pretty cool.


+-------------------------------------------------------------------+
|Filename: star.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3886 |
+-------------------------------------------------------------------+

--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473785

Thanks, Mangesh, but all I did was follow the great instructions from B.
R. Ramachandran. B.R. gets all the credit! I'm impressed.

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473785