dynamic chart title

P

pronto

Dont know if this has been asked before but, how do you make the titl
of a chart dynamic? I want to control the title in a cell in the sens
that if i change the cell text, it would update the title in the chart
I want to avoid clicking and editing the chart title every time.

Any help would be appreciated
 
D

Debra Dalgleish

If the chart already has a title:
--Click on the chart to select it
--Select the chart title
--Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
--Click on the cell that contains the text for the chart, e.g. C6
--Press the Enter key.

If the chart doesn't have a title:
--Click on the chart to select it
--Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
--Click on the cell that contains the text for the chart, e.g. C6
--Press the Enter key.
--Drag the text box from the centre of the chart to the top
--Use the buttons on the formatting toolbar to format the text
 
T

Tom Ogilvy

Once you have the title on the chart, select it, then go to the formula bar
and put in the formula

=Sheet1!A1

Now when you change the text in A1 of Sheet1, the chart title will change.

Not sure that was covered in the link provided.
 
Top