ChartObjects and Columns: Different Size Units?
 

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

ChartObjects and Columns: Different Size Units?
 

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)" wrote in message
...
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