Different chart sizes between Excel 2007 and previous versions

[MD]

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

 

[JLGWhiz]

If you have only tried it on one system that runs xl2007, you might want to
check the system set up. It is possible that the problem is in things like
resolution, etc.
However, if you have the problem on more than one system, then it could be a
difference in the software properties. I have not worked with xl2007, but I
would think that type of condition would have been accounted for during
design.

 

[Jon Peltier]

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

 

[MD]

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
_______





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.

 

[Jon Peltier]

How can I base my chart in cell size and not in points ?

Suppose you want the chart to cover $C$5:$G$20. This code shows what you
need.

Sub ResizeChart()
Dim chtob As ChartObject
Dim rng As Range

Set chtob = ActiveSheet.ChartObjects(1)
Set rng = ActiveSheet.Range("C5:G20")

chtob.Top = rng.Top
chtob.Left = rng.Left
chtob.Width = rng.Width
chtob.Height = rng.Height
End Sub

If the printing of a file in 2007 still doesn't work right, about all I can
do is wave my hands, scratch my chin, and suggest trying different printers
or upgrading printer drivers.

- Jon