Date to refresh in chart title

[chris46521]

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!

[Bernard Liengme]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

Thanks so much!

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>