0 Replies Latest reply: Mar 22, 2012 2:40 AM by Abdur Razak Amod RSS

    Secondary Axis and Dimension with own Expression

    Abdur Razak Amod



      I am currently, using this macro to give the user a choice of enabling the secondary axis, however it is not working:


      sub EnableSecondary

                set chart = ActiveDocument.GetSheetObject("CH04")

                set cp = chart.GetProperties

                cp.Expressions.Item(0).Item(0).Data.AxisData.AxisPosition = 3

                chart.SetProperties cp

      end sub


      I have no clue why this is not working.




      Is there a way of having a bar graph, where you can plot:


      Dimension1 --> EffectiveDate

      Dimension2 --> Expression1

      Dimension3 --> Expression2


      Kind Regards,

      Abdur Razak