ChartObjects and Columns: Different Size Units?

  • Thread starter Thread starter (PeteCresswell)
  • Start date Start date
P

(PeteCresswell)

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top