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.