For this example, I am using Service Category #1 'EmploymentSeeking' which contains Service Type: EmploymentSeekingApplication; Resume&Letters; ResumeInscription; JobOutsideNB; EmailCreation. This chart was made using Excel. This is the target Chart I am attempting to create in access using the clustered column chart wizard.

Context: Here is an example list, below, of some records and sample data from my database. The clustered column chart has to follow this record template.

The Quarterly Periods at our company are as follow:
Q1: April-July Q2: Aug-Sept Q3: Oct-Dec Q4: Jan-Mar

Any help will be greatly appreciated! I will leave tip for anyone solving this.

Is this what you are looking to create (see screenshot)?

Below is the query I built for the Chart (The last column gets the Quarter)

Good day Kevin,

I see a few things that you did that could be helpul here.

Yes, I am looking to create something very similar to this, but only for each service category. The example photo all the way up top is exactly how I would like to create this. For example, Service Type: EmploymentSeekingApplication; Resume&Letters; ResumeInscription; JobOutsideNB; EmailCreation is within Service Category: "EmploymentSeeking". I would create a different chart for each other categories afterwards.

Also, the Quarterly Periods at our company are as follow: Q1: April-July Q2: Aug-Sept Q3: Oct-Dec Q4: Jan-Mar - is there a way I can change the quarters to reflect our company's fiscal year? Because microsoft recognizes April-July as Q2, but for us it's Q1.

I will try to play around with it and let you know when/if I succeed.

Following your example, I was finally able to create the needed chart (below) - the only two issues that I now have:

1) The quarterly period formatting (I would like all dates from April-July to be associated with Q1.. and not Q2).
2) How do I get the data labels to display for each lines?

Drop down the Data Series combo box and check the Display Data Label check box for each series.

Try this for your quarters:

Quarter: "Quarter " & IIf(Month([ServiceDate])>=4 And Month([ServiceDate])<=6,1,IIf(Month([ServiceDate])>=7 And Month([ServiceDate])<=9,2,IIf(Month([ServiceDate])>=10 And Month([ServiceDate])<=12,3,4))) & " " & Year([ServiceDate])

I added the year so you know which year the quarter belongs to. You could put this in its own column for filtering purposes.

Here are another couple of options

Q2: "Quarter " & Format(DateAdd("q",-1,[ServiceDate]),"q yyyy")

Q3: "Quarter" & DatePart("q",DateAdd("q",-1,[ServiceDate])) & " " & Year([ServiceDate])

Great! This seems to solve all my problems. Thank you again Kevin!

Wouldn't have been able to figure this without your help! :-D

You're welcome.