Different in 2007 vs 2003
 

I'm using 2007 working with charts and sharing with my customers that are
saved in 2003. There is other data on the worksheet and everything is the
same (down to the colum width) and duplicated on 28 worksheets in the
workbook. On some sheets for it to fit in the designated area on the sheet,
the chart size is 4.04 & 5.04 and another it will be 3.38 & 3.88. On the
smaller size charts, it looks right on screen but print preview shoves the
chart to the middle of the page. The page setup is fit to one page, and the
same if it is centered on the page or not. If I move the chart on the screen
down and over ~2" it works out fine. If the customer works with it in 2003,
everything is fine.

Is there a way to lock the location of the chart on the page?
Are there other setup features that I need to ensure are the same? I'm not
the original author and lots of data to duplicate.

Is there a site that you can check for know translation/conversion problems
for 2007 back to 2003, so you can stop thinking you're crazy? I had some
problems with 2003 Powerpoint increasing file size greatly when open in 2007
and saved to 2003 format. Something was due attached formating code to the
file.

Different in 2007 vs 2003
 

There are some subtle (and sounds like not subtle in your case) differences
between 2007 and earlier versions, particularly with charts and with
positioning of shapes and charts on the worksheet, often involving printing.
In general you should be using the same version as your clients, especially
if one of the versions is 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Donna" wrote in message
...
I'm using 2007 working with charts and sharing with my customers that are
saved in 2003. There is other data on the worksheet and everything is the
same (down to the colum width) and duplicated on 28 worksheets in the
workbook. On some sheets for it to fit in the designated area on the
sheet,
the chart size is 4.04 & 5.04 and another it will be 3.38 & 3.88. On the
smaller size charts, it looks right on screen but print preview shoves the
chart to the middle of the page. The page setup is fit to one page, and
the
same if it is centered on the page or not. If I move the chart on the
screen
down and over ~2" it works out fine. If the customer works with it in
2003,
everything is fine.

Is there a way to lock the location of the chart on the page?
Are there other setup features that I need to ensure are the same? I'm
not
the original author and lots of data to duplicate.

Is there a site that you can check for know translation/conversion
problems
for 2007 back to 2003, so you can stop thinking you're crazy? I had some
problems with 2003 Powerpoint increasing file size greatly when open in
2007
and saved to 2003 format. Something was due attached formating code to
the
file.

Different in 2007 vs 2003
 

Jon,

I have a similar problem and I am using 2007 exclusively. Do you know if
there is a solution available? I have SP1 installed and on some worksheets
and even within the same worksheet I can get the charts to print out fine but
there is one print area that is just not working - one chart (of four) is in
an entirely different poistion/location than is shown on the worksheet.

thanks,

Brian
--
Brian


"Jon Peltier" wrote:

There are some subtle (and sounds like not subtle in your case) differences
between 2007 and earlier versions, particularly with charts and with
positioning of shapes and charts on the worksheet, often involving printing.
In general you should be using the same version as your clients, especially
if one of the versions is 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Donna" wrote in message
...
I'm using 2007 working with charts and sharing with my customers that are
saved in 2003. There is other data on the worksheet and everything is the
same (down to the colum width) and duplicated on 28 worksheets in the
workbook. On some sheets for it to fit in the designated area on the
sheet,
the chart size is 4.04 & 5.04 and another it will be 3.38 & 3.88. On the
smaller size charts, it looks right on screen but print preview shoves the
chart to the middle of the page. The page setup is fit to one page, and
the
same if it is centered on the page or not. If I move the chart on the
screen
down and over ~2" it works out fine. If the customer works with it in
2003,
everything is fine.

Is there a way to lock the location of the chart on the page?
Are there other setup features that I need to ensure are the same? I'm
not
the original author and lots of data to duplicate.

Is there a site that you can check for know translation/conversion
problems
for 2007 back to 2003, so you can stop thinking you're crazy? I had some
problems with 2003 Powerpoint increasing file size greatly when open in
2007
and saved to 2003 format. Something was due attached formating code to
the
file.