View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Placement of Chart in Worksheet

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