I am attempting to create a stacked columnar chart with version 2 but I am having trouble with the series values being "staggered" and finding no way to set the "Overlap" (-100 to +100) option (in Excel, Option tab when editing the Series) to 100.
I am trying to find a way to do this in version 3 but cannot find it there, either.
The closest thing I could find to doing this was CatSerAxisScaling for the "Series Axis" but this the record for this is not being created (although it seems to be in the default data).
Is this functionality available?
It seems to me that if the functionality is not available, then the value should be defaulted to 100 since this is how OpenOffice.org Calc handles this. Microsoft has a different point of view, obviously.
Daniel.