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

--
Message posted from http://www.ExcelForum.com

Hi Pronto,

See Jon Peltier's web site page:

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


---
Regards,
Norman



"pronto " wrote in message
...
Dont know if this has been asked before but, how do you make the title
of a chart dynamic? I want to control the title in a cell in the sense
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.


---
Message posted from http://www.ExcelForum.com/

Thanks Norman

--
Message posted from http://www.ExcelForum.com

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


pronto < wrote:
Dont know if this has been asked before but, how do you make the title
of a chart dynamic? I want to control the title in a cell in the sense
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

--
Regards,
Tom Ogilvy

"pronto " wrote in message
...
Dont know if this has been asked before but, how do you make the title
of a chart dynamic? I want to control the title in a cell in the sense
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.


---
Message posted from http://www.ExcelForum.com/