Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi friends I need to show on a

Status
Not open for further replies.

cuok

Programmer
Dec 24, 2001
201

Hi friends

I need to show on a form a graph that it's X,Y Axes and values comes from a table underlying the form.
i know that i have the 'graph wizard' option but it not support more than 6 values and i need to show 13 series in one graph.
So I thought to insert an excel sheet that allowed it.
but i don't know how to connect the data that comes from my access table (and apears on the form) to that Excel-sheet in the same form.
in my access program for each ID it can be more than one value for each field (Y axes) - each month (the X axes).
i want to insert more 13 values to each pupil then i need to show the coordinates (time,field) of the 13 through the time - beside the fields on the form. the graph wizard don't allowed more than 6 fields so my idea was to insert into the form an excel sheet so that each time i change the fields values the graph will requery. Other of my future needs is to print this graph.

thanks in advance
cuok
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top