Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rotating an Isoceles Triangle in the shape of a Gauge needle
Hi,
does anyone know how to rotate an Isosceles triange (in the shape of a Speedometer needle) from 0 to 100 (the speedometer dial is 240 deg in shape). i am basically finding the x & y to center the Isosceles needle in the center of the speedometer by taking the LEFT, WIDTH & TOP of the speedometer image. x=shp.Left+Shp.Width/2 y=shp.Top+Shp.Height/2 so the above would remain fixed for centering the Isosceles triangle. but how to calculate the Angle or the new X, Y positions for the point traversing the Speedometer Arc which is 240 degrees in shape based on a cell values ranging from 0 to 100? any help would be most appreciated. Please see attached file. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create shape, name shape, add text to shape | Excel Programming | |||
Use a shape as a gauge. | Excel Programming | |||
If I draw a shape in Excel (say a triangle), can I colour it? | Excel Worksheet Functions | |||
How do I rotate a triangle diagram shape. | Excel Discussion (Misc queries) | |||
How to find a needle in a haystack? | Excel Discussion (Misc queries) |