How to apply a date format in an axis of a chart

The Format property of the Scale Labels object gives you the possibility to figure dates in the desired format in the chart. In order to do this follow the next steps:

1. In the properties of the Axis object on which dates should be deployed (for example, AxisX), set IsDiscrete = true. In the properties of the Series object, set AutoArgument = false and ScaleType = Qualitative;

Axis Series

2. Select the Format property of the Scale Labels object.

3. For example, you can choose the Custom format to set your own Format mask:

Dates will be displayed in the specified format ("MM.dd.yyyy"):

Attention! In order to get the display of the correct date format make sure that data are passed to a chart datasource in the DateTime format.

Add Feedback