how to plot a graph in excel coordinates x y

SCR file out of Windows Explorer and dropping it into the drawing window.ĭo you have an AutoCAD, AutoCAD Architecture, AutoCAD Mechanical, or AutoCAD MEP tips, tricks, or resources you would.

Adding the word CLOSE as the last word in the script to have the linework close back to the start point.Replacing the LINE command with the PLINE command.AutoCAD will launch the Line command then, beginning at the first set of coordinates entered, will draw line segments from one point to the next. In AutoCAD, launch the SCRIPT command, then navigate to where you saved your file in the previous step, then select it and click Open.SCR file (remember where you're saving it). Now Paste the column of coordinates into the file and you should see something like that shown in the figure.Before pasting the coordinates, type LINE as the first word in the file (this will launch the Line command when the script is run), then press.Open Windows Notepad (Start All Programs Accessories Notepad).In Excel, highlight and Copy the column of X,Y coordinates to be used to generate the drawing.Instructions to Create a Drawing with X,Y Coordinates from Excel If X and Y have their own column, you will need to make the necessary adjustments to get them to X,Y format. Prerequisite: The X and Y values need to be in a single cell in the format of X,Y for this to work.

The following tip is from Michael’s Corner May 2009. Michael always has great tips and clear instructions in his monthly “ Michael’s Corner” available on the web as well as a monthly newsletter.

I am currently on vacation but wanted to share a great AutoCAD Tip from my friend the AutoCAD Trainer Guy Michael Beal.

How to plot a graph in excel coordinates x y