Alligning-resizing charts in a Word doc

[Hank Vare]

I have 3 charts pasted into a Word doc. Is there an easy way to get these
charts center-alligned on the page as well as all sized the same? It seems
I can only allign the text and not the charts. I have been manually
stretching/moving the charts but their allignment & placement on the page
never looks "just right".

 

[Jon Peltier]

Word likes to float pictures over the text in a mysterious drawing layer. It's
possible, and in my opinion preferable, to put the pictures in line with the text.
Each picture can then be in its own paragraph, which can be centered quite easily.

It's easy enough to size the whole chart the same. I'd suggest making the chart in
Excel to be the size you need it in Word, so there's no resizing after it's pasted
into Word. In Excel you can align charts with cell boundaries if you hold the Alt
key while moving and stretching them. Simply line up charts over ranges of the same
size to make them the same size.

Sizing the plot areas is trickier, because other features affect this, such as the
number format and number of digits in the axis labels. I have a fairly undocumented
example file that might help with resizing:

http://peltiertech.com/Excel/Zips/AlignChartDimensions.zip

Practice on a copy of your precious charts, so you can always start again.

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