The competition was to come up with a proposal for a section of temporary site hoarding. I decided to draw an abstract timeline highlighting events, people and buildings of the South Bank. I didn’t spend as much time on my entry as I should have, and not surprisingly I didn’t win..
Changing the scale of drawing can often be problematic, but using a simple chart like the one above, it is quite simple. If you are using software that scales using a factor of 1.0 as 100%, then simply adjust the figures above accordingly so for example, 10% is 0.1 and 200% is 2.0. Getting to grips with scales and moving between them takes a bit of practice, and I’ve found that when getting confused about the adjustment needed, writing down some basic calculations and figures often helps a great deal.
Sometimes it can be very useful to have some additional data inside an AutoCAD drawing, so how do I insert an Excel spreadsheet into AutoCAD? It is pretty straightforward to set up and if done correctly, data that is inserted will automatically update when the original spreadsheet is updated within Excel.
Firstly, open the desired spreadsheet then select the data you want and copy it to clipboard.
In AutoCAD go to Edit > Paste Special
In the dialog box, select Paste Link, then as Microsoft Office Excel Worksheet. If the radio bottom is grayed out and un-selectable, as below, then the data currently on the clipboard is unsuitable.
Then click OK. The formatting of the original data should remain, and the data inserted will update inline with any updates made to the external Excel spreadsheet. This means that you won’t need to worry about updating two sets of documents if changes need to be made.
If you found this useful, why not check out some of my other AutoCAD posts?
– How do I add a .CTB file to AutoCAD?
– Free software for students
– How to keep your XREF layers frozen