Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Draw Lines from cell values?
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? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Draw Lines from cell values?
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Draw two lines at given angles | Excel Programming | |||
VBA to draw lines of SPC | Charts and Charting in Excel | |||
draw different weight lines depending on the cell value | Excel Discussion (Misc queries) | |||
draw shape based on cell values | Excel Programming | |||
How do I draw lines..?? | Excel Programming |