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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brite" wrote:

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