Format Chart Title Alignment Vertical doesn't work
 

Hi all,

I want my title flush with the top of the chart area so when I put it
in my Word document, it lines up with the top of the other columns,
but...

Changing to top, bottom or center doesn't do anything. I'm using Excel
2003 SP2 fully updated.

Does anyone else have this problem,i.e. click on the title box,
alignment tab?

Thanks,

Michele

Format Chart Title Alignment Vertical doesn't work
 

Hi,

The alignment refers to the text within the bounds of the chart title
textbox and not the chart titles position relative to the chart area.
As the chart title textbox is not a true textbox the vertical alignment
has little or no effect. The horizontal alignment only has effect if the
chart title contains multiple lines.

To position the chart title you will either manually drag it with the
mouse or use vba code.

Cheers
Andy

mjones wrote:
Hi all,

I want my title flush with the top of the chart area so when I put it
in my Word document, it lines up with the top of the other columns,
but...

Changing to top, bottom or center doesn't do anything. I'm using Excel
2003 SP2 fully updated.

Does anyone else have this problem,i.e. click on the title box,
alignment tab?

Thanks,

Michele


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Format Chart Title Alignment Vertical doesn't work
 

Thanks Andy. It's too bad because there is lots room in the text box
to move up and down. It's already at the top so I guess I have to go
with option B, the VBA code, but I don't really know how to do that.
Thanks again.

Andy Pope wrote:
Hi,

The alignment refers to the text within the bounds of the chart title
textbox and not the chart titles position relative to the chart area.
As the chart title textbox is not a true textbox the vertical alignment
has little or no effect. The horizontal alignment only has effect if the
chart title contains multiple lines.

To position the chart title you will either manually drag it with the
mouse or use vba code.

Cheers
Andy

mjones wrote:
Hi all,

I want my title flush with the top of the chart area so when I put it
in my Word document, it lines up with the top of the other columns,
but...

Changing to top, bottom or center doesn't do anything. I'm using Excel
2003 SP2 fully updated.

Does anyone else have this problem,i.e. click on the title box,
alignment tab?

Thanks,

Michele


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Format Chart Title Alignment Vertical doesn't work
 

Hi,

This will position the chart title top left.

Activechart.charttitle.left=1
Activechart.charttitle.top=1

Cheers
Andy

mjones wrote:
Thanks Andy. It's too bad because there is lots room in the text box
to move up and down. It's already at the top so I guess I have to go
with option B, the VBA code, but I don't really know how to do that.
Thanks again.

Andy Pope wrote:

Hi,

The alignment refers to the text within the bounds of the chart title
textbox and not the chart titles position relative to the chart area.
As the chart title textbox is not a true textbox the vertical alignment
has little or no effect. The horizontal alignment only has effect if the
chart title contains multiple lines.

To position the chart title you will either manually drag it with the
mouse or use vba code.

Cheers
Andy

mjones wrote:

Hi all,

I want my title flush with the top of the chart area so when I put it
in my Word document, it lines up with the top of the other columns,
but...

Changing to top, bottom or center doesn't do anything. I'm using Excel
2003 SP2 fully updated.

Does anyone else have this problem,i.e. click on the title box,
alignment tab?

Thanks,

Michele


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info