MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with plot area ASAP !!!

Posted by caz on April 01, 2001 10:35 PM

Hi all,

I'm trying to dynamically change the width and height of the plot area of a chart, using the following method :

Selection.Height = 140
Selection.Width = 155

The resulting height and width somehow are not always equal to what is specified in the program. I wonder if I'm missing another parameters in my program. Can anyone help ?


Posted by ml on April 02, 2001 11:25 AM

odd. you may want to also specify the top and left positions
just to totally define where the plotarea should be.

ActiveChart.PlotArea.Left = 10
ActiveChart.PlotArea.Top = 10
ActiveChart.PlotArea.Width = 267
ActiveChart.PlotArea.Height = 163