Time-stamping a chart

[Jacson]

I am querying a database and charting the info which I
want to publish on a web page.

I'd like to time and date of the latest query result to
appear on the chart so that users know how current the
information is.

Maybe even embed the last update info in the chart title?
That would work...
Something like...
"Average Time - Last updated 01/08/2004 9:16 AM EST"

Any ideas?

 

[Tushar Mehta]

How is the query executed? Is it through custom VBA code? Or through
native XL capabilities?

If the former, use the code to put the desired title in a cell. Link
the cell to the chart title. For an example of how, see the Excel |
Tutorials | 'Dynamic Chart Title' page of my web site. Or, use the
code to directly create the chart title.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Andy Pope]

Hi Jacson,

You can link the chart title to a cell.
To do it by hand select the chart title, F2 to go to formula bar.
Type = and then either enter the cell address including sheetname or
simply click the cell.

Or with code,
Activechart.ChartTitle.Text="=Sheet1!R1C1"

Also you could just set it direct with code,

Activechart.ChartTitle.Text = _
"Average Time - Last updated 01/08/2004 9:16 AM EST"

I am querying a database and charting the info which I
want to publish on a web page.

I'd like to time and date of the latest query result to
appear on the chart so that users know how current the
information is.

Maybe even embed the last update info in the chart title?
That would work...
Something like...
"Average Time - Last updated 01/08/2004 9:16 AM EST"

Any ideas?

--

Cheers
Andy

http://www.andypope.info