charts with date...

C

chris

Had a question in training today...

I have a chart as a separate worksheet. When I print this
chart, I want to see the date it was printed ON THE CHART.

How do I put the system date (something like =today()...)
on the chart itself so that it updates to the current date
for printing, etc.?
 
J

jr

preview the chart for printing
use SETUP | HEADER/FOOTER
use CUSTOM HEADER (or FOOTER)
option to include date is available.
 
D

Debra Dalgleish

If you want the date somewhere on the chart, e.g. under the chart title,
you can link a textbox to a cell in the workbook:

1. In a cell on another worksheet, type the formula: =TODAY()
2. Select the chart sheet
3. Type an equal sign (it will appear in the formula bar)
4. Select the cell that contains the TODAY formula
5. Press the Enter key
6. Move the text box to the position you want it, and format it.
 

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

Move Chart with Text 0
Possible to Combine reports to's to a single box? 0
Trendline Not Appearing In Chart Problem ? 0
Printing a specific date & hour in project 0
How do I post date a letter? 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Embed the same Excel multiple times 0
Display weeks from a Milestone 0

Top