A little know trick, you can add several levels of axis titles to a chart and they can be linked directly to cells.
So for example, below we have a standard chart with the months on the horizontal axis. However, note that in the data, row 9 and 10 contain some other info that would be useful on the chart i.e. what quarter number the dates refer to and a formula that shows the total for the quarter.
To see the full course contents click here.