Add linked commentary directly to the chart

Please sign up for the course before starting the lesson.

Once you have a chart setup you may need to add some commentary about the information in the chart.

If you add a text box to the chart, every time you change anything you are going to have to edit the text box. A better option is to put your commentary into cells that link directly (and correctly) into the chart.

So below we have included some commentary below the chart that corresponds to that period.

Add Comments to Chart

In this chart we have added some labels that are in cells within the spreadsheet. If you change the cells the labels change and they will follow the column no matter how big or small you make the chart.

Add Comments to Chart

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel