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.
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.
Last edited by GIS2013; 03-05-2014 at 10:46 AM. Reason: typo
Please * if you like the answer
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
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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks