View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Plot area settings...

The PlotArea is that region that includes the plot as well as the axes and
axis tick labels. The PlotArea has inside dimensions (.InsideLeft etc.)
which refer to the actual rectangle that data is plotted within, but these
are read only. You have to manipulate the regular dimensions to change the
inside dimensions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Brad" wrote in message
...
For the following code:

ActiveChart.PlotArea.Select
Selection.Top = 10
Selection.Height = 560
Selection.Width = 960
Selection.Left = 50

I seem to controlling the plot area's top and bottom dimensions, but I am
struggling with the left and right dimensions. While the Selection.Top =
10 code seems to sort of position the plot area appropriately for the
north/south positioning within the overall graph, the Selection.Left = 50,
that and other values I have entered, doesn't seem to help me dial in a
good east/west plot area configuration. And, each time I redraw the chart,
it changes... I a looking to anchor the plot area within chart so that it
remains fixed.

Any ideas or help, greatly appreciated. Thanks in advance for any tips.

Cheers! Brad