Tag Archives: Excel

Drawing in Excel – 1

This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to … Continue reading

Posted in Charts, Drawing, Excel | Tagged , , , | 6 Comments

Importing text files with VBA

Importing data from other programs into an Excel spreadsheet, in the form of text files, is a frequent requirement in engineering and scientific applications.  Often the data will have been formatted to suit printed output and will require processing before … Continue reading

Posted in Excel, UDFs, Uncategorized | Tagged , , , , | 12 Comments