I have a drawing with the x and y as grid references, I have an excel spreadsheet with point information with grid references which are within the range on the drawing. How do I put the excell info onto the drawing?
With a little concatenation in your excel file you can copy and paste (and insert) the whole lot into your drawing via the command line.
Attached is a quick example. Copy and paste everything in Col F to the command line and the points will be plotted.
Dave Hein, P.E.
I have tried both suggestions but seemed to have got nowhere. What I was hoping for was a spot or cross where the coordinates are followed by a description of the object. I'm a complete newby to autocad and quite honestly don't know how I can make it work for me. On a .dwg file I have a map with a grid, when I move my cursor then the coordinates change, so I thought if I can input my coordinates from my excel file I can anotate my map with the objects - tree locations. What I have in one column is this
I would like to put a coloured circle at the grid point to indicate whether it is a conifer or a broadleaved tree. And also include it's database number in the above case 0322. Any more suggestions most gratefully received. Chris
Chris, If your files are too large to attach to email, there are options such as "yousendit.com" as free file FTP sites - you upload your files & just send a link via email for downloading. Might be too late now, but thought you might like to know you have options.
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1