Tips and Rules for Chart Customizing

Stack Date Values per Month

Objective

• If you want to build a stacked chart with date values and stack them per month but the date values are not on the same day, the data points are not stacked.

Solution

• Open axis customizing

  • X axis (DateTime)

    • IntervalType = "Months" - Only show months on the X axis

    • LabelFormat = "MMM" - Only show month abbreviation as labels

    • RoundToIntervalType = "true" - Round date values to beginning of the month

The ticks on the axis are the end of a month, not the beginning of the next one.