且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在 s-s-rS 报告中设置动态轴单位?

更新时间:2023-01-12 19:00:13

我假设将 Y 轴最小值和最大值设置为 Auto 不适合您的情况,无论出于何种原因?

I am assuming that setting the Y Axis min and max values to Auto does not work for your situation for whatever reason?

可能有更好的方法来做到这一点,但这就是我的想法......

There may be a better way of doing this but this is what I thought of...

=
IIF(
    IIF(
        MIN(Fields!ColA.Value) < MIN(Fields!ColB.Value),
        MIN(Fields!ColA.Value), 
        MIN(Fields!ColB.Value)
       )
       < MIN(Fields!ColC.Value),
         IIF(
            MIN(Fields!ColA.Value) < MIN(Fields!ColB.Value), MIN(Fields!ColA.Value), 
            MIN(Fields!ColB.Value)
            )
       , MIN(Fields!ColC.Value)
   ) -5

还有……

=
IIF(
    IIF(
        MAX(Fields!ColA.Value) > MAX(Fields!ColB.Value),
        MAX(Fields!ColA.Value), 
        MAX(Fields!ColB.Value)
       )
       > MAX(Fields!ColC.Value),
         IIF(
            MAX(Fields!ColA.Value) > MAX(Fields!ColB.Value), MAX(Fields!ColA.Value), 
            MAX(Fields!ColB.Value)
            )
       , MAX(Fields!ColC.Value)
   ) +5