Grouping replaces multiple related data points in a series with one data point. The the X and Y values of each grouped data point are calculated using a specified formula and the values of the original data points.