Hi
i'm trying to resize a label so the label get exactly same size as plot area. but it get bigger than it is.
don't know why or what i'm missing?
thx in advance
i'm trying to resize a label so the label get exactly same size as plot area. but it get bigger than it is.

Code:
sub test()
Dim sPoint As Point
Dim ch As ChartObject
Set ch = ActiveChart.Parent
Set sPoint = Selection
With Label1
.Left = ch.Chart.PlotArea.Left
.Top = ch.Chart.PlotArea.Top
.Height = ch.Chart.PlotArea.Height
.Width = ch.Chart.PlotArea.Width
End With
end sub
don't know why or what i'm missing?
thx in advance