Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do i move a chart
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…. -- ExcelUser123 ------------------------------------------------------------------------ ExcelUser123's Profile: http://www.excelforum.com/member.php...o&userid=34448 View this thread: http://www.excelforum.com/showthread...hreadid=542652 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do i move a chart
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do i move a chart
Brilliant just what i was looking for, thanks for your help. Rich....:) :) -- ExcelUser123 ------------------------------------------------------------------------ ExcelUser123's Profile: http://www.excelforum.com/member.php...o&userid=34448 View this thread: http://www.excelforum.com/showthread...hreadid=542652 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting part of a series for a chart? | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |