Spencer,
In a nutshell, create the graph in Excel. Copy the Excel graph and do a paste
special special onto your form. Check the box that says paste link. In the
onload event of your form, use code to pass the parameter to Excel. The graph in
Excel will change with the parameter and the change in the Excel chart will
carry over to Access because the chart in Access is linked to the chart in
Excel.
--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com
· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
