(Msg. 1) Posted: Wed Sep 10, 2008 7:24 pm
Post subject: Could not print a squared grid as exactly squared ! Archived from groups: microsoft>public>excel>printing (more info?)
Hi all,
I create an XY-chart in Excel and use a VBA macro to produce two axes with
the same scale to get a perfectly squared grid.
However when I print that chart, the grid is not squared anymore! And the
printout is different from different printers.
I guess this is due to the differnt resolution of printers and resolution of
the screen. But I do not know how to determine the resolution/aspect ratio
of printers from VBA.
What should I do ? Thanks for your help in advance.
(Msg. 2) Posted: Wed Sep 10, 2008 7:24 pm
Post subject: Re: Could not print a squared grid as exactly squared ! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
To get a square grid on a worksheet with any printer or resolution you can
use Ole Erlandson's code for setting row and column dimensions in mm
On Wed, 10 Sep 2008 19:24:01 +0700, "Le Minh Son" <sanha.RemoveThis@hcm.fpt.vn> wrote:
>Hi all,
>
>I create an XY-chart in Excel and use a VBA macro to produce two axes with
>the same scale to get a perfectly squared grid.
>
>However when I print that chart, the grid is not squared anymore! And the
>printout is different from different printers.
>
>I guess this is due to the differnt resolution of printers and resolution of
>the screen. But I do not know how to determine the resolution/aspect ratio
>of printers from VBA.
>
>What should I do ? Thanks for your help in advance.
>
(Msg. 3) Posted: Thu Sep 11, 2008 5:28 pm
Post subject: Re: Could not print a squared grid as exactly squared ! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have used a macro published by Jon Peltier and Ole Erlandson's code
as your recommend. However the grid is squared on the screen only but
not squared on printed paper.
On Sep 11, 4:59 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> To get a square grid on a worksheet with any printer or resolution you can
> use Ole Erlandson's code for setting row and column dimensions in mm
>
> http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol >
> Gord Dibben Excel MVP
>
> On Wed, 10 Sep 2008 19:24:01 +0700, "Le Minh Son" <sa....RemoveThis@hcm.fpt.vn> wrote:
>
> >Hi all,
>
> >I create an XY-chart in Excel and use a VBA macro to produce two axes with
> >the same scale to get a perfectly squared grid.
>
> >However when I print that chart, the grid is not squared anymore! And the
> >printout is different from different printers.
>
> >I guess this is due to the differnt resolution of printers and resolution of
> >the screen. But I do not know how to determine the resolution/aspect ratio
> >of printers from VBA.
>
> >What should I do ? Thanks for your help in advance.
(Msg. 4) Posted: Thu Sep 11, 2008 5:40 pm
Post subject: Re: Could not print a squared grid as exactly squared ! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have used a macro published by Jon Peltier and Ole Erlandson's code
as your recommend. However the grid is squared on the screen only but
not squared on printed paper.
Le Minh Son
On Sep 11, 4:59 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> To get a square grid on a worksheet with any printer or resolution you can
> use Ole Erlandson's code for setting row and column dimensions in mm
>
> http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol >
> Gord Dibben Excel MVP
>
> On Wed, 10 Sep 2008 19:24:01 +0700, "Le Minh Son" <sa... DeleteThis @hcm.fpt.vn> wrote:
>
> >Hi all,
>
> >I create an XY-chart in Excel and use a VBA macro to produce two axes with
> >the same scale to get a perfectly squared grid.
>
> >However when I print that chart, the grid is not squared anymore! And the
> >printout is different from different printers.
>
> >I guess this is due to the differnt resolution of printers and resolution of
> >the screen. But I do not know how to determine the resolution/aspect ratio
> >of printers from VBA.
>
> >What should I do ? Thanks for your help in advance.
(Msg. 5) Posted: Fri Sep 12, 2008 4:13 pm
Post subject: Re: Could not print a squared grid as exactly squared ! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I find it close enough for my liking.
Try changing the width or height by a decimal point or two to account for
any elongation.
I find if width and height are exactly 7mm the total grid width is a bit
more than length on my printout.
Drop width to 6.8 and measures very close.
I'm running out of ink so will let you experiment.
>I have used a macro published by Jon Peltier and Ole Erlandson's code
>as your recommend. However the grid is squared on the screen only but
>not squared on printed paper.
>
>
>On Sep 11, 4:59 am, Gord Dibben <gorddibbATshawDOTca> wrote:
>> To get a square grid on a worksheet with any printer or resolution you can
>> use Ole Erlandson's code for setting row and column dimensions in mm
>>
>> http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol >>
>> Gord Dibben Excel MVP
>>
>> On Wed, 10 Sep 2008 19:24:01 +0700, "Le Minh Son" <sa... DeleteThis @hcm.fpt.vn> wrote:
>>
>> >Hi all,
>>
>> >I create an XY-chart in Excel and use a VBA macro to produce two axes with
>> >the same scale to get a perfectly squared grid.
>>
>> >However when I print that chart, the grid is not squared anymore! And the
>> >printout is different from different printers.
>>
>> >I guess this is due to the differnt resolution of printers and resolution of
>> >the screen. But I do not know how to determine the resolution/aspect ratio
>> >of printers from VBA.
>>
>> >What should I do ? Thanks for your help in advance.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office