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

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 =93Value (Y) Axis
Crosses Between Categories=94, 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 =3D
False

The box was now unchecked (although still greyed out) and the labels
were aligned correctly.
0
6/30/2010 12:54:08 AM
excel.charting 18370 articles. 0 followers. Follow

0 Replies
607 Views

Similar Articles

[PageSpeed] 54

Reply:

Similar Artilces:

Clusted stacked column chart
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 throug...