I'm posting this (after banging my head against a brick wall for
several hours) in case anyone else should run into the following, and
I would be very interested to know if anyone knows of potential
reasons for the problem.
I made use of Jon Peltier's technique for creating a clustered-stacked
column chart (
http://peltiertech.com/WordPress/clustered-stacked-
column-charts/). This worked fine the first time I used it. However,
thereafter at the step:
"The month names are not centered correctly under the clustered
columns. Format the scale of the secondary category axis (B through K
at the top of the chart) so that the value axis does not cross between
categories. In Excel 2003 and earlier, double click on the secondary
category axis, and uncheck the box that is labeled “Value (Y) Axis
Crosses Between Categories”, I found that the box was checked but also
greyed out so I could not deselect it.
The workaround I used was to enter the following in the Immediate
window:
Activechart.Axes(xlCategory, xlSecondary).AxisBetweenCategories =
False
The box was now unchecked (although still greyed out) and the labels
were aligned correctly.
Similar Threads
