Chart/Graph

B

BOONER

I have a query that selects the data shown below. I would like to display
this data as a series of line charts in a report. I would like to have group
footers for both region, and campaign that contain the charts. So what I
need is for the charts to show the number of leads recieved each day by
region by campaign. I will also need a line chart in the campaign footer
that shows the total number of leads recieved each day (across all regions).
I am having some difficulty using the charts in Access. Where is the best
place to learn about charts in Access?

CAMPAIGN Region Date Leads
Oct-06 TSi - South 10/24/2006 108
Oct-06 FMU West 10/24/2006 93
Oct-06 TSi - West 10/24/2006 75
Oct-06 TSi - East 10/6/2006 1
Nov-06 TSi - West 10/24/2006 1
Oct-06 Northwest 10/15/2006 20
Nov-06 Northwest 10/23/2006 50
Oct-06 TSi - East 10/4/2006 25
Nov-06 Southwest 10/24/2006 2
Oct-06 FMU East 10/15/2006 5
Oct-06 Midwest 10/4/2006 52
Oct-06 Northwest 9/26/2006 2
Oct-06 TSi - West 9/26/2006 4
Oct-06 Northwest 10/5/2006 2
Oct-06 Southwest 10/3/2006 2
Oct-06 Southwest 10/10/2006 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top