When I size my charts in VBA, I make them 288 something-or-others in width.

To get three columns to match that width, the column sizes have to add up to
about 52.72.

Can anybody put a name on those respective units of measurement?

Is there a way for me to assign dimensions using some common unit?
--
PeteCresswell

The chart is measured in points (1/72 inch). The column width is in
characters ('0' in the default font). You can get the column width in vba
using something like:

Range("C:C").Width

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


"(PeteCresswell)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I size my charts in VBA, I make them 288 something-or-others in
> width.
>
> To get three columns to match that width, the column sizes have to add up
> to
> about 52.72.
>
> Can anybody put a name on those respective units of measurement?
>
> Is there a way for me to assign dimensions using some common unit?
> --
> PeteCresswell