Re: Charting Question

There's no method that you can call to change the fields available in the
data section of the chart?

"Duane Hookom" wrote:

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: Data in report wont display correctly
    ... I would try some resizing of the chart control as well as maybe changing the ... Microsoft Access MVP ... "Duane Hookom" wrote: ... Set objGraph = Me!GraphControl.Object ...
    (microsoft.public.access.reports)
  • RE: Altering Row Source Data for Charts from Form
    ... "Duane Hookom" wrote: ... When the report opens, one of the charts is blank, but the ... Can you think of any reason why the fourth chart only works after I cycle to ... between the row source and the record source, ...
    (microsoft.public.access.reports)
  • RE: Data in report wont display correctly
    ... I tried to make chart larger and smaller, ... "Duane Hookom" wrote: ... Dim strReport As String 'Name of report to open. ... Set objGraph = Me!GraphControl.Object ...
    (microsoft.public.access.reports)
  • Re: Charting Question
    ... I would create a normalized union query of the statistics that would place ... 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: Charts / Queries
    ... Is [DATE TO PRINT ROOM] a date field? ... remove if you only want the single chart ... "Duane Hookom" wrote: ... back with your actual Row Source etc. ...
    (microsoft.public.access.reports)