Charts and Graphs for Access 2003

[PL01]

Is there a better add-on for making charts and graphs from access data? The one included with access 2003 is not so good.

 

[dhookom]

I have had great success with Access graphs but your experience may vary.

Depending on my needs, I may connect to Access from Excel to create graphs or pivot charts.

Duane
Hook'D on Access
MS Access MVP

 

[frogbash]

I have an XY scatter plot graph developed in a form. The problem is that I need a 3rd set of data to act as the labels for the graph. For example:

X axis is say the number of sales an agent makes
Y axis is the number of calls the agent makes

I need the labels to depict the names of the agents.

I am not sure how I would need to change my query or what. I am great with VBA in Excel, but access is quite a bit different. Please help.

 

[dhookom]

I have not mastered the scatter graphs in Access. You can record a macro/vba in Excel and copy it into Access to change a chart on an Access form or report.

Duane
Hook'D on Access
MS Access MVP