Sizing charts uniformly
 

With a number of worksheets with similar charts, I need to clip out
the charts basically all the same size for PowerPoint. Would like to
size them to the nearest 5-pix both height and width but none of the
methods are working.

My worksheets are viewed at 70% and the charts are formatted to
produce a professional appearance with small scale fonts, etc. Any
tips for doing this?

Have tried making the charts separate sheets but the fonts get all
messed up. Even tried `sizer´ utilities but none display or read out
the chart boarder dimensions in pixels.

-G

Sizing charts uniformly
 

G,

You can select the charts (use the Shift key as you click them), then right-click one,
Format, Size tab. There you can set the height and width in inches, which will size them
identically.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
...

With a number of worksheets with similar charts, I need to clip out
the charts basically all the same size for PowerPoint. Would like to
size them to the nearest 5-pix both height and width but none of the
methods are working.

My worksheets are viewed at 70% and the charts are formatted to
produce a professional appearance with small scale fonts, etc. Any
tips for doing this?

Have tried making the charts separate sheets but the fonts get all
messed up. Even tried `sizer´ utilities but none display or read out
the chart boarder dimensions in pixels.

-G

Sizing charts uniformly
 

On Mon, 28 Apr 2008 19:20:43 -0400, "Earl Kiosterud"
brought the following to our attention:

G,

You can select the charts (use the Shift key as you click them), then right-click one,
Format, Size tab. There you can set the height and width in inches, which will size them
identically.

Thanks.. that's a great trick. Are their ways
to get the Plot Areas to be uniform as well?

-G

Sizing charts uniformly
 

The utility I mentioned in response to your other post handles plot areas:
http://peltiertech.com/Excel/Charts/...l#AlignChtDims

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


wrote in message
...
On Mon, 28 Apr 2008 19:20:43 -0400, "Earl Kiosterud"
brought the following to our attention:

G,

You can select the charts (use the Shift key as you click them), then
right-click one,
Format, Size tab. There you can set the height and width in inches, which
will size them
identically.

Thanks.. that's a great trick. Are their ways
to get the Plot Areas to be uniform as well?

-G

Sizing charts uniformly
 

On Mon, 28 Apr 2008 20:43:05 -0400, "Jon Peltier"
brought the following to our attention:

The utility I mentioned in response to your other post handles plot areas:
http://peltiertech.com/Excel/Charts/...l#AlignChtDims

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


Yep thanks.. and I misspelled `there´ below.

For clipping out charts as images using PSP, I always round to 5-pix
in width and height .

-G


wrote in message

On Mon, 28 Apr 2008 19:20:43 -0400, "Earl Kiosterud"
brought the following to our attention:

G,

You can select the charts (use the Shift key as you click them), then right-click one,
Format, Size tab. There you can set the height and width in inches, which will size them
identically.

Thanks.. that's a great trick. Are there ways
to get the Plot Areas to be uniform as well?

-G