Help - What is the standard procedure for aligning objects?

D

donbexcel

I'm trying to align a TextBox shape .left and .top value with a MSChart
SeriesCollection DataLabel .top and .left value and it's not working.

This is what the code looks like: shpTextBox.Left =
chtChart.SeriesCollection("Honda").DataLabels(1).Left. I discovered this
when I redirected the Excel VBA code to place the objects over the MSGraph
charts in PowerPoint rather then similar charts in Excel. It works with
Excel charts.

The .left and .top values for the MSCharts objects is way off. Even:
shpTextBox.Left = chtChart.ChartArea.Width + chtChart.ChartArea.Left doesn't
align the TextBox with the edge of the chart area.

Has anyone successfully done anything like this?

I'm calculating a ratio by dividing the Chart Area Height by the Slide
Master Height to get the ratio for Top and I'm dividing the Chart Area Width
by the Slide Master Width to get the ratio for Left. It's not perfect. Is
there a more accurate way of doing this?


Regards,

Don Buchanan
 

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

MSGraph objects .Left and .Top values don't match TextBox .Left and .Top values 0
aligning objects on a slide 2
Macro Help 0
PowerPoint 0
How to change properties of a chart that is not active in Excel in Applescript? 0
"Click and Drag" User Forms in VBA 0
Copy all formats and objects 5
How can I be sure what is selected with multiple layers of objects 4

Top