difference between height and height ? for charts (1 Viewer)

lambuhere1

Registered User.
Local time
Today, 13:01
Joined
Nov 19, 2001
Messages
28
Hi Xlers

I am trying to get the chart height using the following codes.

MsgBox ActiveChart.PlotArea.Height
MsgBox ActiveChart.PlotArea.InsideHeight.

I get two different answers to the above. I am confused. What is the difference between Height and Inside height for a Chart?

Thanks for your help.

Ram P
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 08:01
Joined
Feb 28, 2001
Messages
27,001
Not gonna swear to this, but it is possible that for a 3D chart, these two numbers would be different. Also, note that for 3D charts, the plot area is not square (or circular), but polygonal. So I think the height and width define the CONTAINING rectangle whereas the insideheight and insidewidth define the CONTAINED rectangle.

But don't sue me if that ain't it.
 

lambuhere1

Registered User.
Local time
Today, 13:01
Joined
Nov 19, 2001
Messages
28
Thanks Doc for your reply.

But I am using a 2D Graph and I got this code randomly thru the net, and when I use it on my chart, I get two answers. I don't know why?

Ram P
 

Users who are viewing this thread

Top Bottom