Help with Charts

  • Thread starter Thread starter Jeff F via AccessMonster.com
  • Start date Start date
J

Jeff F via AccessMonster.com

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.
 
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]
 
Back
Top