Hi,

Assuming you have the total value in a cell you could link that cell to
the chart title or an embedded textbox within the chart.

http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Jay3253 wrote:
I need to have a total of my pie chart in the lower right hand corner.
I can't even get the total to show. I would like it to change as the
data changes not just using text. I know this is a newbe question but
I am having a eal brain fart here...



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info