J
Jeff
Greetings!
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!
This seems like a bug to me. Has anyone else run into this problem? Thanks.
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!
This seems like a bug to me. Has anyone else run into this problem? Thanks.