View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Extremely complex problem: showing a value as an 'axis' on a circle

You can do it with code.

You could manually draw your circle with the line, group them, then hide
this shape (or do that in code as well). the code could then copy it and
rotate it to the correct orientation and make the copy visible.

--
Regard,
Tom Ogilvy


wrote in message
oups.com...
The value represents the orientation in degrees from horizontal


So, imagine a circle where

3 o'clock is 0 degrees

12 o'clock is 90 degrees

9 o'clock is 180 degrees



and a value of 180 is represented by:

a picture of a circle with a horizontal line (going straigh across
the diameter)


and a value of 90 is represented by:

a picture of a circle with a vertial line




Is there any way that Excel can translate a value into this pictorally?








BACKGROUND IF YOU ARE INTERESTED:


taken from


http://www.medem.com/MedLB/article_d...C&sub_cat=2017


The "Sphere" column indicates how nearsighted or farsighted you are.
"Cylinder" refers to the measurable degree of astigmatism of your
central cornea. The cylindrical number describes the dioptric
difference between your cornea's steepest and lowest curves.

If you have astigmatism, your cornea is shaped like the back of a
spoon, curved more on one side than the other. The orientation of the
spoon shape can differ from person to person, for instance like a spoon
standing on end or on it's side. ******The "Axis" column describes
the orientation in degrees from horizontal****. Most left and right
eyes with astigmatism are symmetrical.