If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date
I would like to know a way to insert the "Current Date" into the upper right
hand corner of an Excel Chart Area. I know this can be done in MS Access Is there a way to do it in Excel? Thanks, Zach |
#2
|
|||
|
|||
Date
Hi Zach
you may user the header for this (if you have your chart on a separate sheet). goto 'File - Pagesetup - Header/Footer' and insert the date in your custom header -- Regards Frank Kabel Frankfurt, Germany Zach wrote: I would like to know a way to insert the "Current Date" into the upper right hand corner of an Excel Chart Area. I know this can be done in MS Access Is there a way to do it in Excel? Thanks, Zach |
#3
|
|||
|
|||
Date
In a cell in the workbook, enter the formula: =TODAY()
Select the chart Click in the Formula bar, and type an equal sign Select the cell that contains the formula (in the formula bar you'll see a reference to the sheet and cell, e.g. =Sheet1!$J$1 ) Press the Enter key Drag the date to the top right of the chart area If you change the format of the date on the worksheet, the format of the date on the chart will change Zach wrote: I would like to know a way to insert the "Current Date" into the upper right hand corner of an Excel Chart Area. I know this can be done in MS Access Is there a way to do it in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Date
I managed to find my own solution, "View/Header" and then everything is
right in front of me!! "Zach" wrote in message om... I would like to know a way to insert the "Current Date" into the upper right hand corner of an Excel Chart Area. I know this can be done in MS Access Is there a way to do it in Excel? Thanks, Zach |
#5
|
|||
|
|||
Date
Thanks to both Frank and Debra for your assistance.
Zach "Frank Kabel" wrote in message ... Hi Zach you may user the header for this (if you have your chart on a separate sheet). goto 'File - Pagesetup - Header/Footer' and insert the date in your custom header -- Regards Frank Kabel Frankfurt, Germany Zach wrote: I would like to know a way to insert the "Current Date" into the upper right hand corner of an Excel Chart Area. I know this can be done in MS Access Is there a way to do it in Excel? Thanks, Zach |
Thread Tools | |
Display Modes | |
|
|