Link a chart title, label, or text box to a worksheet cell

To easily update a chart or axis title, label, or text box that you add to a chart, link it to a worksheet cell. Changes you make to the data in that worksheet cell automatically appear in the chart.

1. On a chart, select the title, label, or text box that you want to link to a worksheet cell. To select it from a list of chart elements, follow these steps:

   • Select a chart.
     This action displays the Chart Tools tabs.

     Note

     The names of the tabs within Chart Tools differ depending on the version of Excel you're using.

   • On the Format tab, in the Current Selection group, select the arrow next to the Chart Elements box, and then select the chart element that you want to use.

     

2. In the formula bar, type an equal sign (=).

3. In the worksheet, select the cell that contains the data you want to display in the title, label, or text box on the chart.

   Tip

   You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point, for example, Sheet1!F2.

4. Press ENTER.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Create a chart from start to finish