I know the =now() function to show the current date and time on a spreadsheet. But I would like my graphs to show the current date and time (in the upper right corner) on them as well.
Is this possible?
I know the =now() function to show the current date and time on a spreadsheet. But I would like my graphs to show the current date and time (in the upper right corner) on them as well.
Is this possible?
Sometimes I use this way:
I put =NOW() in some cell, say A1
Then:
Select the chart.
Then click the TextBox button on the Drawing toolbar.
Draw the TextBox on the Chart in the upper right.
While, the TextBox is still selected...click in the formula bar, enter =, then click on Cell A1.
Then press Enter.
Whatever is in Cell A1 will appear in the TextBox which is stuck on the Chart.
Regards,
Ron
Beautiful, Thanks Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks