Linking chart title to a cell 2007


S

Sean12

In 2007, how do you link a chart title to a cell?

In my situation, I have a pivot chart and I want the chart title to change
when I change one of the filters. The filters are different sites. I would
like the chart title to change to the one item I select from the list. For
example, I have sites 1, 2 and 3. I select 1 of these, say site 1. How do I
get the chart title to change to "Site 1" automatically?

Thanks,
 
Ad

Advertisements

E

Eduardo

Hi,
Go to you chart, insert , text box, draw the box, go to formula bar enter

=your cell

then each time you update that cell it will automatically populate into the
chart
 
Ad

Advertisements

S

stumac

Hi sean, click on the chart title, go to the formula bar and enter an = sign,
then select the cell you want to link your chart to.

Hth

Stu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top