Drawing Flowers in Excel

Ok, so they’re not flowers, they’re lemniscates.

If you are using IE 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components, you can play with this interactively by clicking on the flower. IE may give you a security warning. Apparently IE doesn’t trust Excel.

The equation is
ampl + PM * SIN(petals * theta) ^ exp

Where
Petals is the number of petals in the lemniscate,
PM is +1 or -1,
ampl is a unit to add to the SIN function
and exp is an exponent
theta is the angle – you can’t change this.

Try the following data:

shape ampl petals PM exp
lemniscate 1 6 1 1
cardioid 1 0.5 1 1
circle 1 0.5 1 2
infinity 1 2 -1 1

Have fun!

Comments are closed.

Bad Behavior has blocked 1666 access attempts in the last 7 days.