"Jon Peltier" wrote:
There are lots of slight differences. The default font is different, so the
column width may be off. If you use points for chart size instead of basing
it on the cell size, your chart may no longer align with cell boundaries. I
haven't used Excel 2007 in enough client projects to have worried about
details like this, so I can't help much further.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"MD" wrote in message
...
I am plotting several charts in Excel on a single page report, controlling
the process with VB.NET; in the VB.NET application I define all the charts
parameters (fonts, sizes, positions, etc.), and the page parameters
(margins,
headers, etc); when I run the application in PCs with Excel 2000 or 2003
the
output page is printed as expected, but if I run it in a PC with Excel
2007,
the charts are displayed bigger and my one-page report becomes a multiple
page report with pieces of my charts dispalyed in several pages. It looks
like the chart sizes in 2007 are measured differently than in previous
versions. Has anybody had the same problem ? If so, is there a workaround
?
Thanks.
MD
Jon:
How can I base my chart in cell size and not in points ?
Also, I am aware about the differences in default fonts, that is why I am
initializing everything to Arial 10pt, using the same cell width and so on,
but still XL2007 prints differently.
Thanks.