Move charts

[jw601]

Hi:

I use VBA to generate a number of charts (8-10 charts).
All the charts overlap each other, so I would like to move
them around, so I can see all the charts and print them on
one page.

Is there a way to do this in VBA?

Thank you

 

[Andy Pope]

Hi jw601,

Take a look at Jon Peltier's site. He has a section covering this things
you will need to do.
(http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/ResizeAndMoveAChart.html)

Hi:

I use VBA to generate a number of charts (8-10 charts).
All the charts overlap each other, so I would like to move
them around, so I can see all the charts and print them on
one page.

Is there a way to do this in VBA?

Thank you

--

Cheers
Andy

http://www.andypope.info