Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Units Produced / (finish time minus start time)=Units Per Hr | Excel Worksheet Functions | |||
ChartObjects | Excel Programming | |||
Change datalabel font size for all chartobjects in a row | Excel Programming | |||
Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel | |||
ChartObjects | Excel Programming |