Using Text Boxes on Charts

I use text boxes to put notes onto charts. But if I move the chart the text boxes don’t move with it. Is there an easy way to achieve this?

By Neale Blackwood

There are a couple of solutions to this problem. The first uses the Ctrl key to select multiple objects. Click the first text box. Then hold the Ctrl key and click the next text box. Keep holding the Ctrl key down and select the chart, making sure it’s the whole chart and not a component of the chart. All objects are now selected. Release the Ctrl key. If you move the chart the text boxes will now move with it. This works for any graphic objects that you want to move together. Click outside the chart area to deselect the objects. If you had held the Ctrl key down as you moved the chart, it would have copied the chart and text boxes.

The other solution allows you to link the contents of the text box to a cell. Click the whole chart then enter = in the formula bar (the space above the column letters and below the toolbar), then click a single cell on the sheet and press Enter. It works best if there is already an entry in the cell. You can move the text box anywhere on the chart and it will always stay in that position when the chart moves. This can be useful to put dynamic notes on charts that change based on text formula in the linked cell. Also, you can link total cells from the chart data for stacked column or bar charts.

Standard text boxes can also be linked to cell contents in the same way. Click the text box and type = in the formula bar and select a cell to establish the link.

Related Articles

Link Text Box contents to cell contents – Text box feature

Text boxes are useful because you can easily place them anywhere on your spreadsheet. You can link the contents of a text box to a cell. First draw a text box on your sheet …
4 Tips to Chart like a Pro – Make your Charts Zing!

Charts are a great way to communicate information in a way that is easy for people to digest and understand. Here are four tips to help you make charts that zing!
Label a single point on a graph …