Chart sizing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GS80 - 25 Jan 2008 08:54 GMT

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

Reply to this Message

Jon Peltier - 25 Jan 2008 12:49 GMT

"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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Hi,
>
[quoted text clipped - 12 lines]
>
> G

Reply to this Message