shape linked to cell

Hey there,
Not sure where is best for this question so i appreciate any one bumping it to a more suitable forum!

I have created a worksheet that performs some simple trigonomotry functions. I would like to get the values from the formula to draw a shape matching the values put in and taken from the formula.

I would appreciate any help on this, be it example workbooks links to sites or tutorials.

Many thanks in advance.

Owaring,

Make a table with several independent variable(s) (input data to the
formula) in their respective column(s), and the formula (result) in a
column. Put in the independent variables that you want to see results for
in your chart. Now select one independent variable column, and the formula
column (use the Crtl key if they're not adjacent). Now make a chart --
Insert - Chart. In step 1, select X-Y Scatter.

Angle Sine
2 =SIN(RADIANS(B2))
4 =SIN(RADIANS(B3))
6 =SIN(RADIANS(B4))
8 =SIN(RADIANS(B5))
10 =SIN(RADIANS(B6))

--
Earl Kiosterud
www.smokeylake.com

"owaring" <[email protected]> wrote in
message news:[email protected]...
>
> Hey there,
> Not sure where is best for this question so i appreciate any one
> bumping it to a more suitable forum!
>
> I have created a worksheet that performs some simple trigonomotry
> functions. I would like to get the values from the formula to draw a
> shape matching the values put in and taken from the formula.
>
> I would appreciate any help on this, be it example workbooks links to
> sites or tutorials.
>
> Many thanks in advance.
>
>
> --
> owaring
> ------------------------------------------------------------------------
> owaring's Profile:
> http://www.excelforum.com/member.php...o&userid=25350
> View this thread: http://www.excelforum.com/showthread...hreadid=388351
>

sorry i should have stated i wanted to have a triangle drawn to scale of the inputted data

Owaring,

At first I had no idea what that means. I'll start guessing. Does that
mean that you have a single variable, and you want the size of the triangle
to be a function of the magnitude of that variable?
--
Earl Kiosterud
www.smokeylake.com

"owaring" <[email protected]> wrote in
message news:[email protected]...
>
> sorry i should have stated i wanted to have a triangle drawn to scale of
> the inputted data
>
>
> --
> owaring
> ------------------------------------------------------------------------
> owaring's Profile:
> http://www.excelforum.com/member.php...o&userid=25350
> View this thread: http://www.excelforum.com/showthread...hreadid=388351
>