Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 162
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Draw two lines at given angles Subodh Excel Programming 0 March 24th 13 02:20 AM
VBA to draw lines of SPC Daniel Charts and Charting in Excel 4 July 31st 07 08:44 PM
draw different weight lines depending on the cell value birder1 Excel Discussion (Misc queries) 1 March 5th 07 11:53 PM
draw shape based on cell values Defoes Right Boot Excel Programming 5 February 10th 06 04:22 PM
How do I draw lines..?? MIKEB Excel Programming 4 October 24th 03 12:22 AM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"