MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Anchoring chart to certain place

Posted by Nikki on July 26, 2000 4:34 PM

Hi. Can anyone tell me how to anchor a chart to a specific site in a macro? The upper left corner of chart should be around U18 and the center is around Y26 if that helps. Thank you so much. Nikki

Posted by Ada on July 26, 0100 6:43 PM

Assuming the chart is "Chart 1", try this code :-

With ActiveSheet.Shapes("Chart 1")
.Left = Range("U18").Left
.Top = Range("U18").Top
End With


Posted by Nikki on July 26, 0100 10:01 PM

Thanks Ada, I'll give it a try. Nikki