+ Reply to Thread
Results 1 to 3 of 3

Adding a dynamic title to a chart

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Adding a dynamic title to a chart

    Hi. c5 shows today() and I'd like c5.value to be the headline of a chart. Hence, in sample file the headline be changed to 05/03/2014 (and tomorrow to 06/03/2014..). Help is needed, thanks.
    Attached Files Attached Files
    Last edited by GIS2013; 03-05-2014 at 10:46 AM. Reason: typo
    Please * if you like the answer

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Adding a dynamic title to a chart

    You may link chart title to cell. Click on title, then in formula bar, then enter:
    =cht!$C$1
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: Adding a dynamic title to a chart

    Splendid. By the way, it's worth mentioning that the method works also with text boxes (eventually I'll put =today() value as a textbox within the chart area rather than as its headline).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Modify dynamic chart title
    By MrPez in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-18-2012, 07:57 AM
  2. [SOLVED] Dynamic Chart Title
    By K m in forum Excel General
    Replies: 7
    Last Post: 12-06-2012, 04:47 AM
  3. How to change title in dynamic chart
    By anthonyu in forum Excel General
    Replies: 5
    Last Post: 06-22-2012, 10:11 AM
  4. [SOLVED] I would like to format a dynamic chart title
    By fayiama in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-15-2006, 10:15 AM
  5. Dynamic updating of chart title
    By gerok in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2005, 02:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1