Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
bump
Hi Nick, did you find the answer to this question? I'm looking for the exact same setting ... No joy so far.
Thanks.
Hi,
Took me a while but I finally found it:
chart.ChartProperties.NumericX = True
Have a great day.