Graphing Data

[Charles Phillips]

Hello,
I'm designing an MS-Access 2003 database to manage a laptop deployment
project.
I have 700 laptops to deploy in 6 locations. I would like to display a graph
of the number or percentage of laptops completed, by location in the
"splash" screen...

Can someone point me to some documentation or examples of this subject???


Thank you,

Charles L. Phillips

 

[Arvin Meyer [MVP]]

Your best bet is to gather the data using an Access recordset or a query,
then use automation to send the data to an Excel chart. A simple example of
Excel automation is here:

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Charles Phillips]

"Thank You"...

Your best bet is to gather the data using an Access recordset or a query,
then use automation to send the data to an Excel chart. A simple example
of Excel automation is here:

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Charles Phillips]

Hello,
I was able to use the "Chart" function to get the results I wanted...


Thank you,

Charles L. Phillips