Making use of Excel to draw curves in AutoCAD
Thread Content
Making use of Excel to draw curves in AutoCAD: In engineering calculations, it is often necessary to draw a curve using AutoCAD. If such a curve is formed by connecting multiple coordinate points, entering those coordinates becomes cumbersome and errors are likely to occur. If the EXCEL application is used to save data and combined cleverly with CAD, it is easy to draw this curve. The specific method is as follows: First, enter the coordinate values in Excel. We enter the x-coordinate values in Column A and the y-coordinate values in Column B, then combine Column A and Column B into Column C. Since in AutoCAD, 2D coordinate points are separated by commas, we enter “=A2&”,“&B2” in cell C2; thus a pair of coordinate values appears in C2. By dragging the mouse to copy the formula for C2, we can obtain a set of coordinate values.
I still don’t understand how to create graphics ? ?
Agree with what was said above; looking forward to it
Is it meant to paste the line or bar charts generated by EXCEL into CAD? Is there another step to follow? Please give me some guidance, LZ
Looking forward to the original poster sharing the next steps.
Moreover, what the original poster wrote: “=A2&”、“&B2” – this formula seems incorrect, right?
This post was last edited by Jianhezhai on 2009-5-28 at 10:20. Why isn’t there any further content from the original poster? ?
Why doesn’t the original poster continue? ? One of the sentences seems incorrect: “So we enter in cell C2: ‘=A2&”,“&B2’.” It should be entered in cell C2 as: =A2&“,“&B2
This post was last edited by Jianhezhai on 2009-5-25 at 10:11. Making use of Excel to draw curves in AUTOCAD: In engineering calculations, it is often necessary to draw curves using AutoCAD. If such curves are formed by connecting multiple coordinate points, entering the data becomes cumbersome and errors are likely to occur. If the EXCEL application is used to save data and combined cleverly with CAD, it is easy to draw this curve. The specific method is as follows: First, enter the coordinate values in Excel. We enter the x-coordinate values in Column A and the y-coordinate values in Column B, then we combine Column A and Column B into Column C. Since in AutoCAD, 2D coordinate points are separated by commas, we enter “=A2&”,“&B2” in cell C2; thus a pair of coordinate values appears in C2. We can copy the formula in C2 by dragging it with the mouse, and this will give us a set of coordinate values. Next, we select the coordinate values of the points for which we want to draw lines; in the example above, this refers to the data in column C. We then copy these values to the clipboard, by using the copy button in Excel to do so. Finally, open AutoCAD; the command line can be seen in the lower left corner. Type “spline” (the command for drawing curves) after “command”. A prompt will appear: “Object/:”. Right-click at that location; a menu will appear, and select the “Paste” command. In this way, the coordinate values from Excel are transferred to AutoCAD and automatically connected to form a curve. Right-click again to end the curve-drawing process, and the curve will be completed. Using the above method, it is easy to draw various curves or line graphs, and it is simple to modify and save the coordinate values in Excel. On some large topographic maps, the X and Y coordinates may be quite high, which can lead to chaotic patterns when filling in custom designs. First, draw a horizontal line near the object that is to be filled; use the OB coordinate system in UCS, select that line, transform the coordinates, and then fill in the area – this will prevent chaotic patterns from appearing.
It’s very simple. Just search on Google for “Using EXCEL to draw curves in AUTOCAD”, and the results will appear – they are posts from other forums