Originally Posted by Jeff

Hello;

When our lab computers were running XP and Office 2003, I could easily set
up the default chart type to XY Scatter, with a few extra modifications, so
that all students would create the same type of chart. Now that we have Vista
and Office 2007, the process does not seem to work properly.

I created a template for an XY Scatter chart ("Scatter with only Markers"),
added a title and axis labels, formatted gridlines and the data marker type.
When I try to use this chart type for a simple 2-column data set, the graph
that's created appears to have two sets of data plotted, instead of one set.
Looking at the data source reveals what is happening: "Series 1" and "Series
2" are created; "Series 1" has the first data column selected for the
"Series Y Values", and "Series 2" has the second data column selected for
"Series Y Values". No entry is included for "Series X Values" for either data
series.

Of course, the correct option should be to have the first column for the
"Series X Values", the second for the "Series Y values". The weird thing is
that I can choose a "standard" XY Scatter chart to create the graph, then
change the Chart Type to my saved template, and the graph appears correctly!
That is the workaround I'm currently using, which works but is a tad clunky.

This seems like a bug to me. Has anyone else run into this problem? Thanks.