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.