Nope, if you can't find it in the UI, it isn't there in VBA either. You
can try replacing the regular axis with textbox labels, which can be
done manually or via VBA, and VBA takes the tedium out of it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Richard wrote:

Thanks for the responses

The 'Number of categories between tick mark labels' was set at 1.
The problem would seem to be that the amount of space for the text is
dependent on the height of the bars in the chart. More bars means smaller
bars and less space for each line of text. When the available height is too
small to fit in the font, the axis labels disappear altogether.
The solutions could be to do something along the lines that BJ had tried, to
turn off some function of Excel, or to use VBA to point to some calculated
value.
I would be interested to hear your thoughts.