Text box to chart

  • Thread starter Thread starter steve_sr2
  • Start date Start date
S

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.
 
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.
 
Back
Top