Drawing with Excel
Our guys—the illustrators—laughed at the notion of drawing with Excel until one of the clients we coach revealed that Excel and Word were her only options for creating in-house work instructions. We had to do some fast learning. Actually, I had to do some fast learning; the illustrators stayed away from it. As it turns out, most simple shapes are possible in Excel, and I learned quickly how to group, align, and rotate objects, as well as add dimension and depth.
As a platform for developing graphic work instructions, especially when compared with a Word file, the Excel spreadsheet format offers some advantages:
- Drawing in Excel is easier than a sophisticated illustration program such as Adobe Illustrator.
- You can scan photos, insert them in Excel, and then trace them into drawings. This allows you to manipulate the shapes as needed.
- Once you develop a library of parts and pieces, you can easily create new instructions. Check out this example...

Of course, Excel also has some limitations:
- You can't import CAD files.
- Isometric/perspective views are limited.
- Using color with customized shapes is tricky.
By the way, you use pretty much the same drawing tools in Word and PowerPoint, so once you've mastered one application in Microsoft Office, you've mastered them all.
Labels: Excel, illustrations, visual work instructions



