Control Property for multiple x-axis columns

[Joseph Fenech]

The below video shows how to use Control Property to select desired single axis. But what if I have a chart with multiple axis and that on x-axis sometime is need YEAR >> MONTH>> WEEK [example Mode Weekly] and other times YEAR >> MONTH [exapmle Mode Monthly]. Howto obtain this Currently I am doing 2 seperate charts. Can this be done trough a dropdown selection and change the number of x-axis

 

https://www.youtube.com/watchv=EVXPlwLhPoU

[Gaia Paolini]

If all you need is to change the level at which the date of the x axis is displayed, you can set up a drop down that selects an integer into a document property, say myProperty, which you then use to tune the axis similar to this:

 

you would not use Column selection, but Set Property Value through.. Fixed Values.

This way you can in principle put however complicated an expression you want on the axis, by generating the entire axis expression in your document property.