From:
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

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

Dear Jeff,

Thank you... for your reply...

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

K


"Jeff Webb" wrote in message
...
I don't believe there's any way to do that directly through the object
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.

-- Jeff

Dear Jeff,

Thank you... for your reply...

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

K

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

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

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


wrote in message news:Q8jUb.5729$213.3270@edtnps89...
Dear Jeff,

Thank you... for your reply...

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

K


"Jeff Webb" wrote in message
...
I don't believe there's any way to do that directly through the object
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.

-- Jeff

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

Dear Jeff,

Thank you... for your reply...

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

K

"Jon Peltier" wrote in message
...

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:


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