Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default Excel 2007 Default Chart Template

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting excel 2007 default template folder Bob Arnett Setting up and Configuration of Excel 2 July 10th 08 05:21 PM
Chart Template Default Directroy excel 2007 Boxey Charts and Charting in Excel 1 March 11th 08 06:01 AM
Need Help with Default Template in Excel T.C. Mann Excel Discussion (Misc queries) 2 May 2nd 07 08:37 PM
How to set the default template in Excel 2007 to what I want it t. Oliver Sparrow Setting up and Configuration of Excel 0 March 13th 07 12:33 PM
Excel template to load automatically as the default template? David Excel Discussion (Misc queries) 1 March 21st 05 01:24 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"