ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dynamic chart title text (https://www.excelbanter.com/excel-discussion-misc-queries/30029-dynamic-chart-title-text.html)

cwinters

dynamic chart title text
 

Is there a way to link text in a chart title to a cell so that the
contents of the cell are displayed as the chart title?


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=377830


bj

Select the title then in the formula bar hit = and select the cell you want
to use.

"cwinters" wrote:


Is there a way to link text in a chart title to a cell so that the
contents of the cell are displayed as the chart title?


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=377830



Peo Sjoblom

Yes. select the chart title, click inside the
formula bar, type =, select the cell with and press enter

Regards,

Peo Sjoblom

"cwinters" wrote:


Is there a way to link text in a chart title to a cell so that the
contents of the cell are displayed as the chart title?


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=377830




All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com