3 Replies Latest reply: Jun 9, 2011 11:23 AM by gaetan_frenoy RSS

    Chart Continuous X-Axis Macro

    nick.harris

      Hi All,

      Basically what i am trying to do is have a macro execute that changes the chart properties to make the x-axis of the chart continuous or not continuous. The code i was trying to use is below but i haven't been able to find anything in the API that suggests the proper syntax.

       

      sub test

      if ActiveDocument.Variables("vCheck").GetContent.String = "YearMonth" then

      set chart = ActiveDocument.GetSheetObject("CH382").GetProperties

      chart.ChartProperties.(?????) = (True or False I'm guessing??)

      chart.SetProperties chart

      end if

       

       

      end sub

       

       

      I could be going about this the wrong way but i can't really thing of any other way to do it.

      Any help would be much appreciated.

       

      -Nick