dynamic chart title

[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

 

[Norman Jones]

Hi Pronto,

See Jon Peltier's web site page:

http://peltiertech.com/Excel/Charts/Dynamics.html

 

[pronto]

Thanks Norman

 

[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

 

[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.