Scaling Automatic Minimum above zero...

[RayTheOtherRay]

I'm publishing a web page with MicroSoft Excel XP from a PivotTable.
The chart is a 3D clusterd column chart. On some filtering, the
minimum value will need to be negative. On others they should be zero.
I need to produce a setting that will force some automated positive
minium scaling values down to zero without forcing negative minimum
scaling values up to zero.

Thanks in advance!
RayTheOtherRay <><

 

[Alvin Bruney]

Couple ways to do this, probably the most easy is to use the chscaling
object of the axis in question. Alternatively, you can use an appropriate
number format.

--

________________________
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

 

[RayTheOtherRay]

Thanks Alvin!

Previously the ChScaling object wasn't working. It turned out to be
the influence of something else that was causing that. I'm currently
using...

pc.Axes(1).Scaling.Minimum = 0

....to get the current good results. I discovered through some other
filtering of the PivotChart, though, that there some negative values
that this suppresses. I guess that now, I'm looking from some sort of
hook to check the lowest value in the data for that axis and set
pc.Axes(1).Scaling.HasAutoMinimum to True if the value is below 0.

Thanks!
Ray <><