I don't know if the use of a chart within Microsoft Access should be
discussed here or in the access thread - i know that Access uses the Excel
Charting object (or i think it does)...

I have a graph that i'm trying to display showing the history of a few
fields.

There are 2 tables: Person and PersonHistory... For each person there is
1..many records in person history...

So the chart would show the trend of these fields in PersonHistory over time
(week_ID is one of the records in personhistory...)

I am putting the chart on form that will enable the person to select a
person from a dropdown containing all of the rows in the person table... Also
on this form is a check box for each statistic that would let the user
determine what to show on the graph (it defaults to having all show up)...

1) I have it working now that as you change what's visible in that dropdown
the data in the subform containing the chart changes, which is visible if i
put the chart on in datasheet view. However, when it's in the chart view, as
i scroll thru the records ti shows a blank chart unless the first person is
selected. How do i make the chart get refreshed based on underlyind data???

2) How would i change the lines on the chart that were visible?

3) The legend is showing "sum of <stat 1>" "sum of <stat2>" etc instead of
having the label just be "stat1", "stat2" etc... I put the fields in there by
dragging and dropping from the field list into the main box... Is there a way
to edit the legend values (i thoguht there was in excel, but don't see how to
get there).

Thanks so much, this is my first foray into the land of charts.

-Ben