Date

  • Thread starter Thread starter Zach
  • Start date Start date
Z

Zach

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
 
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
 
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
 
I managed to find my own solution, "View/Header" and then everything is
right in front of me!!
 
Back
Top