Chart - Title Widths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

From: <[email protected]>
Subject: Chart - Title Widths
Date: Tuesday, February 03, 2004 12:43 PM

Chart - Title Widths

Does anyone know how to find the width of a title/axis title?
 
Andy Pope and I have already answered your first post on this question.
Of course, mine was just paraphrasing what he said on the subject a
while back.

- Jon
 
Dear Jeff,

Thank you... for your reply...

Is there a way to center like you would in lets say Publisher?

K


Jeff Webb said:
I don't believe there's any way to do that directly through the object
Click to expand...
model. You can calculate it from the font and the text using Windows APIs
(it's in GDI). If you don't need it to be super-accurate or if you are
always using the same font/size, you can just use a simple calculation based
on the average size of characters.
 
Dear Jeff,

Thank you... for your reply...

Is there a way to center like you would in lets say Publisher?

K
 
Sorry... I ment to say Jon...


Dear Jeff,

Thank you... for your reply...

Is there a way to center like you would in lets say Publisher?

K



model. You can calculate it from the font and the text using Windows APIs
(it's in GDI). If you don't need it to be super-accurate or if you are
always using the same font/size, you can just use a simple calculation based
on the average size of characters.
Click to expand...
 
I don't know how Publisher centers labels. Did this work (from my
earlier post)? How is it different from Publisher?

activechart.ChartTitle.left = activechart.ChartArea.width
activechart.ChartTitle.left = activechart.ChartTitle.left/2

- Jon
 
Back
Top