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

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

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

Ada


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

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