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