Chart Limitations / Alternatives?

[sainttomn]

Good afternoon all,

I'm working on a rather hefty report that needs to display 4 items over a 12 month period. It is a tracking report for a customer service department, and will track the CS representative's number of calls, productivity, quality, and average call time on a monthly basis.

Essentially, 48 data fields per rep, for about 60 representatives.

I've got a functional table, form, and basic query, and I can get the numbers to display fine and well on the report. It's pretty basic.

Where I'm running into trouble, is the apparent limitations of using a chart/graph on a report. I seem to be limited to 6 data points, which makes reporting for 12 months something of a pain.

Is there any added functionality I can find for Access reports in the form of an add-on?

Otherwise, I believe my best option is to link the Access data table to an Excel sheet and do my graphing there.

Thank you for your advice and assistance,

-Tomn
www.thelazercat.com

[June7]

It is possible to graph more than 6 data points. I have one graph that loads 50 for a fairly smooth curve. Check out this thread http://forums.aspfree.com/microsoft-...hs-445065.html

[sainttomn]

Thanks June. I wonder if it's a difference between Access 2003 and 2010, perhaps.

I'll take a look at the links in the other post and see if it makes sense.

www.thelazercat.com

[June7]

No, I originally built the database in 2003. Now can't remember if the version in that link is 2003. I will have to check that out tonight.