Hello... I have not been able to fix the plotarea size of a chart I'm making.
Here's the code:
For Each chtobj In ActiveSheet.ChartObjects
With chtobj
.Width = 200
.Height = 200
End With
Next chtobj
ActiveChart.PlotArea.Width = 1000
ActiveChart.PlotArea.Height = 1000
I want the PlotArea to occupy most of the chart area, hence the 1000...
However, it doesn't work. I'm getting a very smal plotarea.
What to do?
Thanks,
Albert