POINT LABELS

POINT LABELS

MarkvonT
Observer Observer
1,158 Views
3 Replies
Message 1 of 4

POINT LABELS

MarkvonT
Observer
Observer

Once I have uploaded a set of grading points from an excel sheet to AutoCAD, I'd like to know how to label each reference (point) with Z(height). To clarify I have each point on excel with X..Y..Z...I then upload the coordinates to AutoCAD but I would like to know how to automatically label each point with their specific heights.

 

Thanks,

0 Likes
1,159 Views
3 Replies
Replies (3)
Message 2 of 4

pendean
Community Legend
Community Legend
You need to be using MAP3D or Civil3D variants for that more intuitive ability: the former is free to anyone with an active subscription, the latter requires a new subscription https://www.youtube.com/watch?v=2Nh9UtOPYkg
0 Likes
Message 3 of 4

LyleHardin
Advisor
Advisor

A plain AutoCAD solution would be to make the point a block with an attribute that would report the Z value.

Then, you can use your Excel sheet to create a script file that inserts the points at the proper coordinates, and enter the attribute value with the z value.

Without testing, your script file made from the Excel sheet would look something like this:

-Insert pointxyz x,y,z 1 0 z   (give or take)

where pointxyz is the block name. x, y, z are the coordinate values of your point. The 1 and 0 are scale and rotation. That last Z value would be filling in the attribute value of the block.  Note that I'm probably missing something because I'm just doing this from memory.

Message 4 of 4

LyleHardin
Advisor
Advisor

Another option if they already exist in the drawing as points and you don't want to re-insert them is a relatively simple lisp routine to find all the points and enter text next to them that reports the Z value of their coordinate.

I've looked in my arsenal, but I don't have any that do specifically that. 

You could also use your same Excel file to create a script file to just enter Text at that coordinate.

 

-TEXT x,y,z 0.1 0 Z

 

Where -TEXT is the command, x,y,z is the coordinate, 0.1 is the size, 0 is the rotation, Z is the elevation value for the text.

 

 

0 Likes