I am trying to make a chart template to draw an xy scatter plot using two
columns. I follow the instructions on p. 410 of John Walkenbach's new book.
It does make a template. The problem is that when I use two new columns of
data, select them both and call the template it plots them both as if they
were y variables against an x axis of 0-n (where n is the number of data
points). If I select only the y variable, it plots it against an x axis of
0-n.

This worked in Excel 2003. why not now?