Help with Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff F - 30 Nov 2005 15:51 GMT

I am having the toughest time trying to get this to work. I have a report
that list numerous projects, for each project I need to graph two data sets
over time (savings and average savings per month). Any assistance is greatly
appreciated.

FYI my data looks like:

Proj Month Savings Avg.
201    Jan    100    10
201    Feb    150    15
201    Mar    125    12
202    Jan    200    20
202    Feb    205    21

I would like one graph per project to show up in the project detail or footer
section of the report. Thanks in advance.

Reply to this Message

Duane Hookom - 01 Dec 2005 14:30 GMT

Set your report's record source to a query of each unique Proj value. Create
your chart's Row Source with something like:

SELECT [Month], Savings, Avg
FROM [My Data Looks Like]
ORDER BY [Month];

Set the link master/child properties of the chart control to [Proj]

Signature

Duane Hookom
MS Access MVP
--

>I am having the toughest time trying to get this to work. I have a report
> that list numerous projects, for each project I need to graph two data
[quoted text clipped - 15 lines]
> footer
> section of the report. Thanks in advance.

Reply to this Message