Automated XY plots from Microsoft Excel

Abstract:

We present a macro program which greatly simplifies the process of making X–Y (scatter) and triangular plots using the spreadsheet program Microsoft Excel®. The program draws on user-defined “type-plots” to establish plot format, allowing a great amount of flexibility in style and presentation. Predefined templates can be used to define fields or lines for specific purposes and these can be retained easily from plot to plot facilitating rapid comparison of different data sets. The program requires only the addition of some simple control characters to be able to draw data from existing spreadsheets with little or no reformatting.

Website