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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MD" wrote in message
...


"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.