How do i move a chart

E

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….
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top