Hard carriage return in Category Axis Title?

  • Thread starter Thread starter E Harris
  • Start date Start date
E

E Harris

Hello all.

I am creating a chart whose X-axis represents a ratio of Calcium to
Phosphorus.

I've stacked the numbers in the ratio. The numerical values of the
axis thus look something like this:

0 25 50 75 100 125
0 45 90 135 180 225

This can of course be done by assign the Category Labels to a column
in a spread sheet-- a column where I already entered the labels with
the hard carriage return embedded, suing ALT-Enter.

So now I want the Title of the axis itself to be similiarly stacked,
such as:

Calcium Concentration
Phosphorus Concentration


But the textbox for entering the Axis Title doesn't accept the
ALT-Enter hard return.

I'm familiar with VBA, but just being able to access the Axis Title
via code doesn't seem to get me any further.

I'm sure there's a simple answer.

Ideas, please?
 
Instead of an axis label, you could use a textbox, with text orientation
set vertically, or insert a WordArt object.
 
Put the label, complete with line break, into a cell. Select the axis
title, press the = key, then select this cell with the mouse.

- Jon
 
Back
Top