Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting excel 2007 default template folder | Setting up and Configuration of Excel | |||
Chart Template Default Directroy excel 2007 | Charts and Charting in Excel | |||
Need Help with Default Template in Excel | Excel Discussion (Misc queries) | |||
How to set the default template in Excel 2007 to what I want it t. | Setting up and Configuration of Excel | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |