The Y axis issue is a well known problem and I've seen microsoft bulletins on
it, but can't find them now. One workaround is to add a couple of spaces
to the end of the Y axis label and format those to the same color as the
background of the chart.

For the 3D column series issue, you can format the series for the 3d part
and change the scale for # of series between tick marks from 2 to 1. I'm
not sure how to do this in VBA, but I usually just record that as I do it and
then clean up the code as necessary.

HTH,
Barb Reinhardt
"chet" wrote:

In Excel2003 under WXPSP2, a sequence of procedures computes frequency
and cumulative distributions and relative frequency and relative
cumulative distributions for each of two treatments for each of ten
variables. Two previously created custom chart types (one line with
markers and one 3D column, each displaying the two series for the two
treatments for the given variable) are invoked in the chart generating
procedure and various properties defined for charting the relative
frequency and relative cumulative distributions. Two problems have
arisen. (1) Either the last half or last 10% of the final letter of
the xlValue axis title is missing. How can I force ExcelVBA to show
the whole title without reducing the font size? There seems to be
plenty of room on the chart to fill out that final letter. (2) The
second series label is missing from all the 3D column charts for which
there are "many" (e. g., 50 or more) categories; but when there are
only a "few" categories (i. e., 11), the columns are big enough that
the depth axis for the series names will show both series names on the
chart. How can I force ExcelVBA to place the second series name (only
5 letters long) next to the first series name (also only 5 letters
long) for all the other 3D column charts? Thank you for any help or
suggestions.