I am graphing a set of numbers from a query on a line chart in a report. I need to also place the average of those numbers as a line on the chart (see line in red below). I cannot figure out how. Any help would be GREATLY appreciated!!!
Novice
Windows 8 
Access 2010 32bit
Graphing the average of a set of numbers
I am graphing a set of numbers from a query on a line chart in a report. I need to also place the average of those numbers as a line on the chart (see line in red below). I cannot figure out how. Any help would be GREATLY appreciated!!!
VIP
Windows 7 64bit Access 2010 32bit
Need another field for the Avg in the graph RowSource. Is the RowSource SQL a CROSSTAB?
I analyse graph issues best when I can work with data. If you want to provide, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Graphing/Charting - Access vs. Excel
Pie Graphing problem
Posting Permissions
Reply With Quote