Date to refresh in chart title

C

chris46521

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Date in cell to update upon Pivot Table refresh 4
display pivot refresh date? 3
How to add straight line from cell value in pivot table chart 1
Pivot Chart Problem when Refreshing 1
macro to keep chart dual axis format 1
Put the date from a Cell automatically in a Chart Title? 4

Top