Im scratching my head a bit on this one, having to admit that Im not very familiar with much if any of Access charting features, Modern or Classic. I have 3 sets of documentation due (IPOS, IBA & Review) on a regular basis and my hope was to get a bearing on how much of this document falls in any particular month so I can schedule accordingly.

I thought the modern stacked column bar chart would be ideal for form/dashboard. The data source is a query that Ive used to both summarize and reformat the dates. The results are displayed in the charting but other than the Axis Category - IBAYearMonth all of the data labels are incorrect. All the data labels for each document read the same. If it isnt the chart settings that need to be reworked, wondering if my data needs to be better summarized to reflect more count than date?

Including my SQL statement:

SELECT qry_Documenation_Review.Journey_Number, Year([ipos_due]) & "-" & Format(Month([ipos_due]),"00") AS IPOSYearMonth, Year([Review_Date]) & "-" & Format(Month([Review_Date]),"00") AS ReviewYearMonth, Year([IBA_Due]) & "-" & Format(Month([IBA_Due]),"00") AS IBAYearMonth
FROM qry_Documenation_Review
WHERE (((Year([ipos_due]) & "-" & Format(Month([ipos_due]),"00"))<>"-"));