Can Excel Draw Shapes or Angles based on Data?

**chesspupil** · 04-16-2008, 08:42 PM

Can Excel Draw Shapes or Angles based on Data?

I have a radiation Excel file that solves for Radiation intensity using Distance and shielding as reducing factors.

Similar to a circle of light being less intense with distance so is radiation.

I need excel to draw a circle from a point specified based on a value I give.

For example at 1 ft I might have 500 R in 1 hour (life threatening!)

At 16 feet I have about 2 R in 1 hour (not safe for too long)

These circles would be overlayed on an map.

I would like to draw a new circle at various distances, simialar to a bullseye.

I would also like a triangle drawn based on angles and SIN / COS / TAN formulas

Could this be done in VB or preferably without.

**shg** · 04-16-2008, 08:58 PM

I need excel to draw a circle from a point specified based on a value I give.

Sure:

Please Login or Register  to view this content.

**shg** · 04-16-2008, 09:05 PM

Cross-posted at http://www.ozgrid.com/forum/showthread.php?t=89151

**chesspupil** · 04-16-2008, 09:31 PM

I see your example, but I am lost...

I need a circle center-pointed over another image and its diameter would change based on a value in a cell.

In another instance I need a triangle drawn (as an Excel shape)
based on angles, leg lengths, etc, based on a cell value

Thank you, I hope this clarifies.

**shg** · 04-17-2008, 12:25 AM

B3 & C3 contain the {x,y} center of the circle. C2 contains the radius.

**chesspupil** · 04-17-2008, 04:27 PM

but where in my workbook will the circle be drawn?

**shg** · 04-17-2008, 05:03 PM

I assumed that you would plot them on a chart, with the map as the picture backdrop for the plot area. Example attached.

**chesspupil** · 04-17-2008, 07:08 PM

pasted your formula into excel w/ data. was this VB data?

I did not see a circle

**shg** · 04-17-2008, 07:23 PM

No, it was data from the formulas I posted.

Did you look at the circles on the plot?

**chesspupil** · 04-17-2008, 10:21 PM

sorry if this seems dense...

I saw your image. I was looking at my workbook after pasting the data, using data import from saved text. I tried shaping it, but I saw no circles in various attempts at changing... could I please have the xls file?

Thank for your patience

**shg** · 04-17-2008, 10:47 PM

See attached.

**chesspupil** · 04-19-2008, 07:59 AM

thank you for the example. I need time to play with the chart to better phrase my next question

Ill be back

**kopam.kanale** · 11-03-2011, 09:01 PM

That example of yours is very very helpfull!!! TNX a lot!!!!

**SDruley** · 11-04-2011, 02:15 AM

shg,

I see that you are up to your spells of brilliance again

steve

**dibble.dustin** · 04-30-2016, 09:01 AM

New to the forum. Your spreadsheet is great, is there any way to do this with a sector instead of the circle?

Thanks,
Dustin

**newdoverman** · 04-30-2016, 03:31 PM

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.