Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cwinters
 
Posts: n/a
Default 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

  #2   Report Post  
bj
 
Posts: n/a
Default

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


  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
axis title text box is wrong size in chart for excel 2003 hey_scott Charts and Charting in Excel 5 February 16th 06 01:25 AM
Relative Chart Title? Nick M Charts and Charting in Excel 6 June 22nd 05 10:24 PM
Prevent non-numerical data (e.g. text) from plotting on a chart jaweiss Charts and Charting in Excel 1 March 19th 05 06:54 PM
Dynamic Text in a Chart hlsr2003 Excel Discussion (Misc queries) 1 February 10th 05 01:43 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 06:49 PM


All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"