Ed said:
How do you draw to scale in Excel?
The short answer is, you don't...
The slightly longer answer depends on what you mean by "draw" - XL is
not a drawing program, and how a worksheet is rendered depends on many
things, including the print driver, the default font, the printer
quality setting and the zoom/fit to page settings.
Having said that, you can manually scale autoshapes or other shape
objects by ctrl-clicking on them, choosing Format shape, and setting the
size. You can then set the shape properties to Move and Size with cells,
but scaling cell widths, which can take on only certain subdivisions of
font size, is tricky at best.
In any case, you'll have to try printing things to see if what XL sends
to the printer retains its relative dimensions.
There are enough free/shareware drawing applications out there that I'd
really suggest using one of them if you need accurate scale drawings.
