Excel --- Physical dimensions of a chart object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nimmi Srivastav - 21 Jan 2007 01:38 GMT

Is there a way to know the physical dimensions of a chart object on a
worksheet? I have data in several worksheets and I would like all my
charts to be of the same size (obviously this means that data with a
smaller range of values will be more spread out than data with a larger
range of values).

Thanks,
Nimmi

Reply to this Message

Gary''s Student - 21 Jan 2007 13:17 GMT

This is just an example:

Sub Macro2()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
n = ActiveSheet.Shapes("Chart 1").Width
m = ActiveSheet.Shapes("Chart 1").Height
MsgBox (n & " BY " & m)
End Sub

Note that you have to activate the chart AND select the ChartArea.

Signature

Gary''s Student
gsnu200702

> Is there a way to know the physical dimensions of a chart object on a
> worksheet? I have data in several worksheets and I would like all my
[quoted text clipped - 4 lines]
> Thanks,
> Nimmi

Reply to this Message

Rate this thread: