I have data to be represented by a pie chart and need to include a text box
with the grand total of the data somewhere on the chart.

I've been able to create an embedded pie chart but can't get the text box
with the grand total to stay on the chart when I click off the chart area.
Then I tried to create the chart on a chart tab instead of making an embedded
chart--I can get the text box to stay on the chart but then I can't get the
data to update when it changes (the series values remain the same--it's
reading a total row).

I need the pie chart to be updated as new data is added AND I need the grand
total to be displayed (I assume via a text box). Is it a dream for me to
have my cake and eat it too?? :)
--
Thanks so much!