How do i move a chart

[ExcelUser123]

I’m trying to record a macro that will get data from a row on sheet 2, create a chart and place it on sheet 1 and then move the chart to say row 20. This will be nested inside a loop so that next time a chart is created it will be placed at row 40. So that when a page is printed, each will have a different chart in the same place as the previous page.
I have managed to get the chart on sheet 1; problem is they all get placed on top of one another and in the middle of the sheet. I have tried dragging while recording but then the problem is trying to calculate the number to get it placed in the exact position lower down the sheet.


Rich….

[Andy Pope]

Hi,

Top position the activechart object use it .Parent.Top property.
So something like this,

activechart.Parent.top = activesheet.rows(20).top

obviously you will need to use a variable to increment the actual row
number.

Cheers
Andy

ExcelUser123 wrote:
> I’m trying to record a macro that will get data from a row on sheet 2,
> create a chart and place it on sheet 1 and then move the chart to say
> row 20. This will be nested inside a loop so that next time a chart is
> created it will be placed at row 40. So that when a page is printed,
> each will have a different chart in the same place as the previous
> page.
> I have managed to get the chart on sheet 1; problem is they all
> get placed on top of one another and in the middle of the sheet. I have
> tried dragging while recording but then the problem is trying to
> calculate the number to get it placed in the exact position lower down
> the sheet.
>
>
> Rich….
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

[ExcelUser123]

Brilliant just what i was looking for, thanks for your help.

Rich....