shape linked to cell

  • Thread starter Thread starter owaring
  • Start date Start date
O

owaring

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

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

I would appreciate any help on this, be it example workbooks links t
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))
 
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?
 
Back
Top