View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Brad Brad is offline
external usenet poster
 
Posts: 57
Default Plot area settings...

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