Add commentary to the axis

Please sign up for the course before starting the lesson.

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.

Add commentary to the axis

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel