Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Continuous X-Axis Macro

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

3 Replies
Not applicable
Author

bump

Not applicable
Author

Hi Nick, did you find the answer to this question? I'm looking for the exact same setting ... No joy so far.

Thanks.

Not applicable
Author

Hi,

Took me a while but I finally found it:

chart.ChartProperties.NumericX = True

Have a great day.