Chart Placement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a new chart (chart.add) in my code, but how can I place the
charts upper left corner at a certain cell - say C3? If I cant use a cell as
a reference how can I then place my chart? Note that I dont want to move the
chart, but place the chart right as it gets created.

Thanks
The Doctor
 
You can use the Top and Left properties of the cell and
the chart to line them up together.

'After the chart is created
With ActiveSheet.ChartObjects("Chart 1")
.Activate
.Top = Range("C3").Top
.Left = Range("C3").Left
End With

tod
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HIDE VALUE 0 FROM CHART 1
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
Paste Excel Chart into Existing Powerpoint Chart 1
Placement of Chart in Worksheet 1
Excel 2010. How to copy chart format to all charts in sheet 2
Chart Label Positions 1
Using =Offset in Charts 1
Chart DataLabel Placement Error 2

Back
Top