Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date in a chart title
ex..... Sales for May 14
How do I put a the current date in the title of the chart above so it comes up automatically? I'm thinking something like ..=now() but not sure how put in the title. Then how do I change the =now() (or whatever is used) to the date it is saved? Thanks, Frank. |
#2
|
|||
|
|||
Right click on the chart tab, click on view code, and enter the following
code: Private Sub Chart_Activate() ActiveChart.ChartTitle.Characters.Text = Date End Sub - Mangesh "FJ Shepley & JM Pfohl" wrote in message ... ex..... Sales for May 14 How do I put a the current date in the title of the chart above so it comes up automatically? I'm thinking something like ..=now() but not sure how put in the title. Then how do I change the =now() (or whatever is used) to the date it is saved? Thanks, Frank. |
#3
|
|||
|
|||
Frank -
An easier approach that doesn't require a macro. In a cell somewhere, enter a formula like this: ="Sales for "&TEXT(NOW(),"mmm dd" Then select the chart title, press the equals key, then click on the cell. The formula bar will show a formula like =Sheet1!$A$1 Press Enter, and the title is linked to the formula in the cell. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ FJ Shepley & JM Pfohl wrote: ex..... Sales for May 14 How do I put a the current date in the title of the chart above so it comes up automatically? I'm thinking something like ..=now() but not sure how put in the title. Then how do I change the =now() (or whatever is used) to the date it is saved? Thanks, Frank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |