Chart sizing

[GS80]

Hi,

I'm working with the Excel object model for 2007 and am trying to set up a
page so that it is neatly formatted with graphs and cells lining up in a
specific sequence. I'm having difficulties in how the chart sizing works
compared with the cell width etc. Ideally i want to set the set certain cells
in the chart to the width of a column in the charts plot area. I can get the
plot area width and left position but the sizes don't appear to relate to the
cell sizing.

Is there any way i can do this? All help is greatly appreciated.

G

 

[Jon Peltier]

"certain cells in the chart"?? You mean, for example, you want the category
axis scale to be aligned with the underlying cells? This can be done, within
a pixel or so.

Note that there is a difference between the PlotArea.Height (and other
properties) and the PlotArea.InsideHeight (and other InsideX properties).
The InsideX properties describe the plotting rectangle without adding any
space for axis ticks and labels and the like. The InsideX dimensions are
read-only, so you have to set the outer dimensions with enough slack so the
InsideX dimensions end up how you want them.

Also note that there's a certain small offset, that a plot area that begins
at 0,0 is slightly lower and to the right of the corner of the parent chart
object. This offset is somewhat different in 2007 than prior versions.

- Jon