View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brite Brite is offline
external usenet poster
 
Posts: 11
Default Show Total In a Text Box in a Pie Chart

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