Re: Charting Question

I would create a normalized union query of the statistics that would place
each stat value for each employee in a separate record. Then use a
multi-select list box to select which statistics to include in the graph.
Use a crosstab query as the Row Source of the chart. This should provide
appropriate labels for the lines in the chart.
--
Duane Hookom
MS Access MVP

"BenWeber" <BenWeber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4901E4E-E9A1-4720-83FA-90E57305AACE@xxxxxxxxxxxxxxxx
Here would be the values in the result set as an example

Week Stat A Stat B Stat C
1 5 5 4
2 5 6 4
3 6 6 5

and so on...

All of that is in the person history table. The chart is only showing one
person at a time, so ignore the existance of the person table...

So the two questions are that
1) i have checkboxes for a user to be able to toggle on and off stat A/B/C
in the display and i don't know how to change what's being charted
(there's
actually 12 statistics, so it gets busy)

2) why is the legend showing "Sum of Stat A", "Sum of Stat B", etc instead
of just "Stat A", "Stat B", etc. The data set includes only one row per
week
for the person being displayed at that time......

Thanks,
-B

"Duane Hookom" wrote:

Can you share the structure of the statistics table? I'm not sure if
statistics are multiple columns or or a single field an multiple records.
--
Duane Hookom
MS Access MVP


"BenWeber" <BenWeber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C3253B00-A181-475E-8327-41EC7FC12B0F@xxxxxxxxxxxxxxxx
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) How would i change the lines on the chart that were visible when
someone
changes the checkbox?

2) 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





.

Relevant Pages

  • Re: National SLOWdown?...not in Vegas!!!.
    ... all kinds of charts and statistics that don't mean anything. ... The Alladin when broke to and now look at ... over, this article, chart, statistic says its not really happening. ...   Driving and seeing the way these buildings are going up, ...
    (alt.vacation.las-vegas)
  • Re: Charting Question
    ... statistics are multiple columns or or a single field an multiple records. ... There are 2 tables: Person and PersonHistory... ... So the chart would show the trend of these fields in PersonHistory over ...
    (microsoft.public.access.reports)
  • Re: Charting Question
    ... "Duane Hookom" wrote: ... multi-select list box to select which statistics to include in the graph. ... Use a crosstab query as the Row Source of the chart. ... i have checkboxes for a user to be able to toggle on and off stat A/B/C ...
    (microsoft.public.access.reports)
  • Re: Charting Question
    ... "Duane Hookom" wrote: ... query as the Row Source of the chart. ... multi-select list box to select which statistics to include in the graph. ...
    (microsoft.public.access.reports)
  • Re: Purchase for Sporgy
    ... I do have a statistical chart in the works for pro & college footbal, ... His name is John Dewan of Baseball Solutions.com. ... statistics, beyond simple things like yards allowed or points scored. ...
    (alt.vacation.las-vegas)
Loading