4 Replies Latest reply: Mar 23, 2017 4:36 AM by Mambi Badi RSS

    Calculated Dimension

    Mambi Badi

      Hello everyone,

      i want to add a calculated dimension to a chart dynamically (via a macro), but it doesn't work

      any idea ?


      Sub TestFunc

        set pchart = ActiveDocument.GetSheetObject("CH01")

        pchart.addDimension " = if ( Product='AAA', Field1, Field2 ) "

        set chartProperties = pchart.GetProperties   

        pchart.SetProperties chartProperties

      end sub