Chart axis titles/labels

[Ali]

Hi,

On a chart i have 3 levels of titles labelling the x
axis. When i try to change the alignment on the
title/labels, only the first level (closest to the axis)
changes, is there a way of changing the next level up and
so forth? am thinking probably through vb?

many thanks ahead

 

[Jon Peltier]

Ali -

I have an example on my web site for making staggered axis labels:

http://www.geocities.com/jonpeltier/Excel/Charts/Staggered.html

The technique makes use of a dummy series, which is invisible but which
has data labels attached to the invisible points. You don't want your
labels staggered, but you could use the technique to put labels where
you want them, in the orientation you want. Even if the invisible
points are outside the plot area and would not be shown in the chart,
the data labels still appear where you want them.

- Jon