Chart size

[Deborah Mowry]

Is there a way to make the User defined chart be made a specific size when
created? We will be making multiple charts and I wish them all to be a
specific size as they are then copied to Word.
Thank you

 

[Jon Peltier]

Deborah -

If you make the chart with the Chart Wizard, you are stuck with the
default size and position, which is *approximately* half of the height
and width of the active pane, centered within the pane. You can resize
charts by dragging their corners, and if you hold down the Alt key, the
chart edges stay aligned with cell boundaries, so you could make the
charts the same size this way.

If you want to use VBA, my Quick Chart VBA page has some hints:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/QuickChartVBA.html

For example, use the ChartObjects.Add method do add charts to the active
sheet. You specify the size and position explicitly.

If you're using VBA, you may as well code the copy-paste operations as
well. I have more hints here, mostly with PowerPoint, but also some
rudimentary Word examples:

Using Excel with Other Office Applications
http://www.geocities.com/jonpeltier/Excel/XL_PPT.html

- Jon