Hello,
I would like to place a chart at a certain location on a worksheet. e.g.,
the upper left hand corner of the chart starting at cell C1. Is there an
easy way to do this?

thanks,

bill

You can manually drag the chart to the desired location, or use
VBA code like the following:


Dim ChtObj As ChartObject
Set ChtObj = ActiveSheet.ChartObjects(1)
ChtObj.Top = Range("C3").Top
ChtObj.Left = Range("C3").Left


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Bill" wrote in message
k.net...
Hello,
I would like to place a chart at a certain location on a
worksheet. e.g., the upper left hand corner of the chart
starting at cell C1. Is there an easy way to do this?

thanks,

bill