**
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



This posting was submitted via the Web interface

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






<>

This posting was submitted via the Web interface

Richard,

Make sure you choose custom footer and click on the date icon.

-----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






<>

This posting was submitted via the Web interface

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

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