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