Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem

G

GodotIsDead

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top