Plot and plot elements dimensions

Schadenfreud

New Member
Joined
Jan 22, 2014
Messages
29
szgZagR.png

I'm making a program that will rearrange scatter plot labels so they don't overlap. It's almost finished, but there are a few more kinks I need to iron out.
1. For some reason ActiveSheet.ChartObjects(1)'s dimensions are not right (I have only one chart on the sheet). From what I saw the height is up to about where the XY cross is. How can I get the correct chart area dimensions?
2. The other thing is that the Point objects have no height, only coordinates (Left, Top). Are those coordinates the center of the point icon, because I need to compensate for the image?
3. Also about the labels, are the (Left,Top) coordinates of the label its top left angle (just wanna make sure)?

I hope my question is clear enough. Please ask if you need more information.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,214,651
Messages
6,120,744
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top