PC Review


Reply
Thread Tools Rate Thread

shape linked to cell

 
 
owaring
Guest
Posts: n/a
 
      19th Jul 2005

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

--
owarin
-----------------------------------------------------------------------
owaring's Profile: http://www.excelforum.com/member.php...fo&userid=2535
View this thread: http://www.excelforum.com/showthread.php?threadid=38835

 
Reply With Quote
 
 
 
 
Earl Kiosterud
Guest
Posts: n/a
 
      19th Jul 2005
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" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> 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
>



 
Reply With Quote
 
owaring
Guest
Posts: n/a
 
      19th Jul 2005

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

 
Reply With Quote
 
Earl Kiosterud
Guest
Posts: n/a
 
      20th Jul 2005
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" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> 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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show shape on cell select, Hide shape when cell is deselected Max Microsoft Excel Programming 5 27th Jan 2010 12:04 PM
3 option boxes to linked cell-linked cell to be 1,2,3. Paula Microsoft Excel Programming 1 29th Oct 2009 02:43 PM
Move shape, object, pic to center of new cell based on cell value =?Utf-8?B?enp4eGNj?= Microsoft Excel Programming 4 7th Jul 2006 01:58 PM
How can Word update the linked filename for Shape object automatic =?Utf-8?B?5aSn54aK?= Microsoft Word Document Management 0 18th Nov 2005 04:59 AM
Deleting a shape and the cell contents the shape is in. John DeFiore Microsoft Excel Programming 3 9th Oct 2003 04:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:10 AM.