Date to refresh in chart title

  • Thread starter Thread starter chris46521
  • Start date Start date
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
 
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

Date in cell to update upon Pivot Table refresh 4
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Pivot Chart Problem when Refreshing 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Using VBA to create charts 1
display pivot refresh date? 3
Pivot Table Refreshing 2
Wait till pivot finishes refreshing 1

Back
Top