Text box to chart

[steve_sr2]

Is there a way to tie a cell to a chart? I have a doughnut chart with one
series that has 2 different pieces of data. One for open (VALUE = 7) and one
for closed (value = 10). I would like to put the total amount of these two
values (17) in the middle of my doughnut chart. Is this possible? I can do
it with a text box but that would require the number to be manually changed
each time. Any suggestions? Thanks in advance.

 

[steve_sr2]

Thanks to those who looked. I figured out.... I added another series and
tied to my total cell. This created another doughnut around the outside of
my first. I then changed the color of the newly created chart to match my
background color. This made it "invisible". I then added values to the
chart and moved the value to the center of my original chart.