Show Total In a Text Box in a Pie Chart

[Brite]

I'm 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 textbox 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

Total points = 140 <= this is the number I'm trying to show in a textbox on
top of the pie chart someplace.

thanks for your help

 

[Luke M]

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.

 

[andy62]

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.
Any ideas?