LinkBack URL
About LinkBacks
I have a report workbook that needs to display current time in a chart.This chart is embedded in one of the worksheets, I can move the chart to it's own sheet if is necessary. How can I accomplish this?
Display system time in a chart
I have a report workbook that needs to display current time in a chart.This chart is embedded in one of the worksheets, I can move the chart to it's own sheet if is necessary. How can I accomplish this?
hi,
This can be done by changing the Chart Title into a link or by creating a linked textbox (see attached file for an example) to a cell which contains the time.
Another option is to include the time in print outs using a page footer (this may depend on your version of Excel?).
For other useful charting tips check out Jon's site:
http://www.peltiertech.com/
Edit: File now attached...
hth
Rob
Last edited by broro183; 11-03-2007 at 02:33 AM.
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks