| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date to refresh in chart title
I have a pivot chart where I would like date in the title to refresh t the current date when the data in the accompanying pivot table i updated. Is this possible to do with code? BTW, there is other tex with the date in the title. Thanks for your help -- chris4652 ----------------------------------------------------------------------- chris46521's Profile: http://www.excelforum.com/member.php...fo&userid=3590 View this thread: http://www.excelforum.com/showthread.php?threadid=57384 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date to refresh in chart title
No need to program
In some cell (say Z1) enter =TODAY() Clear the text in the title, type = and click on Z1 Want text and date? In Z1 use ="some text "& TODAY() best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "chris46521" wrote in message ... I have a pivot chart where I would like date in the title to refresh to the current date when the data in the accompanying pivot table is updated. Is this possible to do with code? BTW, there is other text with the date in the title. Thanks for your help! -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=573845 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date to refresh in chart title
Thanks so much! Bernard Liengme Wrote: No need to program In some cell (say Z1) enter =TODAY() Clear the text in the title, type = and click on Z1 Want text and date? In Z1 use ="some text "& TODAY() best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "chris46521" wrote in message ... I have a pivot chart where I would like date in the title to refresh to the current date when the data in the accompanying pivot table is updated. Is this possible to do with code? BTW, there is other text with the date in the title. Thanks for your help! -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=573845 -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=573845 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in Chart Title | Charts and Charting in Excel | |||
| Put the date from a Cell automatically in a Chart Title? | Excel Programming | |||
| Date in a chart title | Charts and Charting in Excel | |||
| Format Date in Chart Title | Excel Programming | |||
| add date to a chart title? | Excel Programming | |||
![chris46521[_36_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
