Create the chart as normal. Have the total in another cell. Click on the
chart and add a normal text box from the drawing toolbar, then in the formula
bar type =and click on the cell with the total. Then right click on the
border of the text box and then orderbring to front. (I have tested this on
2003)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"steph" wrote:

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!