MSGraph objects .Left and .Top values don't match TextBox .Left and .Top values

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?

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

Help - What is the standard procedure for aligning objects? 0
PowerPoint 0
Method 'Left' of object 'DataLabel' failed 2
Changing Left and Top properties 2
SetViewRect - attainable values for top and left 1
Getting Top and Left properties from Range object in C# 2005 2
Match Values and Copy Rows 3
Problem programming .SeriesCollection().XValues and .Values 7

Top