Are you showing the chart as it's own sheet or as an object on a sheet?
I think the only way you can do it on screen would be to have the chart
as an object on a sheet and use the cell's below (or around) the chart
to display other data. The formula in Excel for the current date and
time is =NOW().
Insert a new sheet and right-click the chart, choose location, and
change the chart to be an object in the new sheet. To get the default
excel grey around the chart play with the view in Page Break Preview
mode.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Phillips, Richard Mr CN
Northrop Grumman 5 SIG CMD
Sent: Wednesday, December 31, 2003 8:46 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Using an excel chart to display ARS data...
That's a great solution if the report will be printed, but this one will
mainly be displayed onscreen.
How do I make that date (or footer) appear when it displays on screen?
Thanks,
rp
-----Original Message-----
From: Allison, Dawn [mailto:Dawn.Allison@DIGITALNET.COM]
Sent: Wednesday, December 31, 2003 3:27 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Using an excel chart to display ARS data...
I can't get into Excel right now to verify this but if you have your
charts set up as separate worksheets just go into the page setup and in
the section where you can identify footers and headers make the footer
equal to the date. it should update automatically.
-----Original Message-----
From: Phillips, Richard Mr CN Northrop Grumman 5 SIG CMD
[mailto:Richard.Phillips@HQ.5SIGCMD.ARMY.MIL]
Sent: Wed 12/31/2003 9:07 AM
To: ARSLIST@ARSLIST.ORG
Cc:
Subject: Using an excel chart to display ARS data...
**
I have an Excel workbook with 2 worksheets, one for data
(hidden), and one with a chart representing that data.
When the excel file is opened, the data worksheet is updated
from my Remedy form via ODBC.
I'm looking for a way to have the date/time (at the time of the
update) display on the chart.
Has anyone done this before?
Thanks,
Rick
4.5.2
Ora 8i
Solaris 8
Excel 2000
<>
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web
interface
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com
Previous Topic
Index