Total in Text Box in Pie Chart in Excel

[GuruT]

I am building a pie chart for a project at work. There are two categories in the pie chart. Points achieved, and points yet to achieve. I'm wondering if there is a way to create a text box that is automatically linked that will show the total number of points on the pie chart someplace. So for example: points achieved = 40 / points yet to achieve = 100. Then the total points = 140 <= this is the number I'm trying to show in a text box on top of the pie chart someplace. Thanks for your help.

[Koman]

First, have a cell somewhere in your worksheet calculate the total (by adding the data used in your chart. Then, select your chart, type the equal sign, and then then select the cell with the formula you just created.

[Leanne]

In a worksheet I have references in a text box to cells on another sheet. However, sometimes (not sure of the pattern) the text box does not update. So it might show "n=978" even though the cell it is referencing now shows "n=1174". Editing the text box (F2, then "enter") gets it to "wake up" and show the correct data, but I shouldn't have to do that manually each time.