Question Help create a basic quartery bar chart

[josephbupe]

Hi,

I have never created a chart report before. Now, I need to create a bar chart that will show the following information:

1. Number of "TYPE" recorded per quarter of each year
(TYPE can be either "HUMAN TRAFFICKING" or "PEOPLE SMUGGLING")

2. A combo box for selecting a year to view incidents per quarter (as above)

3. A legend for TYPE: "HUMAN TRAFFIKING" and "PEOPLE SMUGGLING"

In my current chart, what I am seeing is that I have three quarters (in Query_Incidents_Crosstab) with data but only two appear.

Please, see attached mdb I am working on.

Your help is appreciated in advance.

Joseph

 

[josephbupe]

Hi,

As a follow-up to my previously un-answered question, I have made some attempts but got stack along the way in the attached copy of my application.

1. There is a problem when I include a year field (calculated on the fly from the Incident_Date) in a query, because the year is also appearing under the legend and as a column in the chart

2. I want the bar chart to project data for a single year as 1st Quarter, 2nd Quarter 3rd Quarter etc

3. I also want to give users an option to select any year available in the combo box to populate the chart

Kindly peruse attached mdb file and advise.

I will appreciate.

Joseph

 

[mahenkj2]

I would suggest to have a look at Pivot chart in create forms section. This will give you much more flexibility in selecting year/month/quarter/week kind thing on date fields and not only that but also in other fields as well.

regards.

 

[josephbupe]

I would suggest to have a look at Pivot chart in create forms section. This will give you much more flexibility in selecting year/month/quarter/week kind thing on date fields and not only that but also in other fields as well.

regards.

In than the attachment in my first post is a pivot chart. Although it showed me data per year i could not figure out how to group by quarter per year. Which is why i was tempted to go a different way.

I hope somebody will have a good look and advise further.

Thanx.

Joseph

 

[mahenkj2]

Basically, if you have date field, Access will work for you and by right clicking on the pivot chart, if you would have added that date field in filter area then you would be able to see data in many ways.

But, you already have cross tab so I do not know if you have the possibility to make chart on simple query. Otherwise, you may get all the features desired by you with the help of pivot chart.