![]() If the number of points is few, the automation code above can be discarded. Paste.ĭo the same for each of the points. Pause and select the specific point of interest. They are building blocks in the automation process. Record the next 6 steps with the macro recorder. Group the arrow and the line as a single object. Format the line the same color as the chart background (default is white). Position this line so that it 'extends' the arrow (i.e., the tips of the two touch). Create a straight line of exactly the same length. On the worksheet, from the Drawing toolbar, create a horizontal arrow pointing to the right. Just not trivial.Ĭreate the scatter chart with the desired (X,Y) coordinates. Creating multiple vectors is best done with code since the process is not trivial. I've visited Jon's web site, and he has provided few links to try. ![]() and its "Rotation" to be 119.81 degrees anticlockwise from + ve X-axisģ.e Repeat for all the given N 4-value data points select the Arrow -> Format AutoShape -> Size choose a reasonable scaling factor for the Arrow, say, 400.0 vector) must coincide with this vector reference data point X=1.50 & Y=2.20 Plot the point (1.50, 2.20).ģ.c For demonstration purposes, draw an Arrow (from the Drawing Tool), and place it anywhere (for now) in the chart plot area.ģ.d Here is what you need to do (by a macro ?) to have the Arrow represents the vector at that point: Let me explain.ģ.a Using the same notations (X, Y, V, theta) to describe a given data point, suppose a single data point is tabulated as (1.50, 2.20, 328.40, 119.81).ģ.b The XY-Scatter Chart would have, say, value X-axis 0.0 to 2.0, and value Y-axis 0.0 to 2.5. Most impotantly, the size of each vector has nothing to do with the scale you choose for the X-axis & Y-axis. So, if I have, say, 200 data points (vectors), can Excel (2003) handle that many series in one chart?ģ. You are suggesting that each vector has to be treated as a new series. First, I agree with you that the X-axis and Y-axis of the 2D Chart would have to be the same in order to have, for exanple, a wing planform or a circular cylinder plotted realistically on the same 2D Vector chart.Ģ. There are, however, a number of issues / problems:ġ. Thank you for your thorough and impressive reply! (re.: 2D Vector Plot). If you give it your best effort to incorporate the utility he shares on his web page and you cannot get it to work then post back here, or if you deem it best, you might PM Jon (he is a member of Mr. Especially if you want your x-axis & y-axis to have the same scale, Jon's page is a great help. The subject of the page is not vector plotting (though it would not surprise me if Jon were to have a page on the subject), but rather the subject of that particular page is how to make the graph's grid "square". I was not recommending that you contact Jon directly, but rather follow the link I gave to one of his web pages. Then click on the other marker for that line (series) and change its shape to something like a 7 or 8-pt-sized triangle or something to distinguish the end point from the start point. Then change the marker to something like a circle size 7 or 8. (note the singular "Point" not "Points"). ![]() Your popup menu should say Format Data Point. and tell Excel to paste as a new series.įor something like a vector plot you may want to take the formatting a step further than the default and click on the vector line, then click on the end data point and then click again on the end data point. Then click on the graph and from the menu Edit | Paste Special. After we have our chart created we can add vector 2 by selecting B4:C5 and copying to the clipboard. ![]()
0 Comments
Leave a Reply. |