Chart column displaying from max down to value instead of from min up to value...

[RayTheOtherRay]

I'm using Microsoft Excel XP to publish a clustered 3D column chart
from a PivotTable. Sometimes the chart displays with the columns drawn
from the floor up. When I change a filter it will draw the columns
from the ceiling down.

I've been experimenting with .Crosses, .CrossingAxis, .CrossesAtValue,
..HasAutoMinimum, .HasAutoMaximum, .Minimum, .Maximum and more and am
yet to find an answer. Can you point me to the property that governs
such behavior?

Thanks!
RayTheOtherRay <><

 

[RayTheOtherRay]

The current, yet dissatisfying solution to my problem (opportunity?) is
to publish the PivotChart when the filtered data is displaying a value
axis scale minimum of zero. When you to this the zero value is
published to the default settings of the PivotChart in Office Web
Components.

Prior to doing this, we searched the published code for the offending
figure (.8 in our case) where the columns were starting above the zero
mark. This search yielded an html tag,..

<;WaterLevel>;0.82000000000000017<;/WaterLevel>;

Further searches of the OWCVBA10 and OWCVBA11 help files showed no
exposed "WaterLevel" property. I decided to try setting it, anyway.
So far it has not worked. It is only partially satisfying to know the
setting that affects the observed chart behaviour when I can't get to
it and programmatically control it.

RayTheOtherRay <><

 

[Alvin Bruney]

see my earlier post

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin