You can merge Chart axis labels using the Group feature. When combined, the data associated with labels is aggregated, creating a new summary label category. With grouping, only your view of the data is changed. You can easily ungroup grouped categories and return to your original label values.
For example, your chart report is structured with data item Units (sold) dimensioned by Year and Quarter. You can group the first and second quarters together to summarize activity for the first half of the year. The data is aggregated in a new label.
This feature is available only for items on the x axis or z axis.
To toggle the group axis labels feature:
Select the individual labels to be grouped.
(You can group contiguous or discontiguous labels, but the labels must be part of the same dimension item or axis.)
Select (Un)Group Items on the shortcut menu.
The selected labels, and their associated data values or chart objects, are combined. The resulting label is displayed with an asterisk (*) to indicate a grouping.
To ungroup items, reselect the grouped items and choose (Un)Group Items on the shortcut menu.