How to align an embedded chart in a worksheet?

[sjh]

Hi, I am trying to align the charts (pie chart and bar chart) on a worksheet. I tried the following code, but I get an error with the .LEFT line.

With Worksheets("Budget Report&quot
'.ChartObjects("BarChart&quot.Left = .Columns("B&quot.Left
.ChartObjects("BarChart&quot.Top = 200
End With

The .TOP property correctly puts the bar chart at 200, but after I add a Pie chart, the bar chart gets pushed to the bottom. Any idea why?

With Worksheets("Budget Report&quot
'.ChartObjects("PieChart&quot.Left = .Columns("B&quot.Left
.ChartObjects("PieChart&quot.Top = 600
End With

Thank you for your help,

 

[xlbo]

have a look at the "TopLeftCell" property of the chartobject. This will anchor the chartobject to a cell

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244