VBA Charts

[IanCassidy]

Hi All

I'm trying to setup a small database reporting system which basically picks up purchases of our various services. We are trying to analyse the historic data of all the records in the database and get graphs / reports of the data from the statistics.

• The data is entered from a form for each customer.
• Each customer can choose various TYPES of services.
• Within the TYPEs(categories) of services we have various individual Service names.

Types of charts required;

1. For each TYPE/category we need show graph of the No of customers who bought each servicefrom a query result
2. We need to do some calculation on the data and allocate a score to each customer. Then we need to create a chart to show how many of the customers scored different range of scores
3. View trends of customers activities as well as our responses to their demands.

Now although we have created the forms and tables etc we are having a few problems with creating the graphs etc when we need to create the graphs based on Query results. For instance if we need to do a age-wise graph with age range on X-axis and No of customers on Y axis... how do we do this? Is it through the VBA code or some other better way. (we CAN do VB / SQL etc so coding is not a problem but what is the BEST way to handle the graphs with query results.)

TIA
Ian

 

[apr pillai]

You must process and bring the data into a form that can go as Source Data for various type of Graph Charts you can create in MS-Access. If you have some basic knowledge in creating Charts in Excel then you know how to approach this problem. Few Links of Articles which explains how to create charts in MS-Access are given below. You may visit them to get a general idea.

http://www.msaccesstips.com/2007/08/ms-access-and-graph-charts.shtml
http://www.msaccesstips.com/2007/09/ms-access-and-graph-charts2.shtml
http://www.msaccesstips.com/2008/06/working-with-chart-object-in-vba.shtml
http://www.msaccesstips.com/2008/07/column-chart-and-vba.shtml
http://www.msaccesstips.com/2008/07/pie-chart-object-and-vba.shtml
http://www.msaccesstips.com/2008/02/crosstab-union-queries-for-charts.shtml