Stagger X-axis text

[Deborah]

In 1-2-3 I could stagger the text in the X-axis. In Excel it seems
that I can only rotate the text to 90 degrees.
Is there a way to stagger and leave horizontal?
Specifically, I have all the provinces (or 10 of them) across the axis
and they take up room when spelt out (no abbreviations allowed). I
would rather the first, third, fifth ... etc. be higher and the
second, fourth etc. be lower to allow the chart to be narrower and
still read the text clearly.

Cheers,
Deborah

 

[Peter atherton]

-----Original Message-----
In 1-2-3 I could stagger the text in the X-axis. In Excel

it seems

Deborah

I would use a Bar Chart (a Column chart turned on its
axis). This allows long descriptions in the titles.

Regards
Peter

 

[Jon Peltier]

Deborah -

I have an example that shows how to get labels to appear this way:

http://peltiertech.com/Excel/Charts/Staggered.html

Unfortunately it doesn't work with Excel XP, and I haven't had a chance
to update my web page.

- Jon

 

[Andy Pope]

Hi Deborah,

Maybe one of theses techniques will suit.
(http://www.andypope.info/charts/staggeredlabels.htm)

Cheers
Andy