"TheMilkGuy" wrote in message
Howdy,
Based on this chart:
http://code7700.com/images/crfi_crosswind_limits.png
Is this possible?
When a pilot enters a number of degrees and a wind speed, draw an line
from 0,0 out the degree line, then down once you intersect the wind speed
arc.
Or would VB have to draw the chart first?
I don't quite follow your objective but a chart like the one in your image
can be made without VBA, just formula values, briefly
For each of the arcs add scatter lines without markers with x/y values like
this
x = Radius1*COS(RADIANS(n))
y = Radius1*SIN(RADIANS(n))
where values n are in incrments from 0 to 90, steps of 5 should be enough to
show smooth arcs. So you'd have pairs of x/y columns adjacent and linked to
the same column of n values
And where each radius is in equal steps to separate the arcs like a grid od
circles, or indeed at whatever radius you want.
add line series for the straight lines that radiate from x/y=0/0, the mid
point of the quarter circle, either for indicater lines (like a sort of
grid) or your particular line. Again with formulas the angle of the line can
change when a single vlaue is changed in some cell
You will probably need to resize the plot-area to make the X & Y axes
equivalent, ie same visual scale, so 0-100 on each axis look like a square.
Regards,
Peter T