Sizing charts uniformly

[gabbey.maps]

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

 

[Earl Kiosterud]

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.

 

[gabbey.maps]

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

 

[Jon Peltier]

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

- Jon

 

[gabbey.maps]

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

- Jon

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