How do i move a chart

  • Thread starter Thread starter ExcelUser123
  • Start date Start date
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….
 
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
 
Back
Top