Modern Chart still needs work (dates, stacked bars fix, add Reverse Order)
You probably should have a category, just for Access Charts, but anyway....
Using Dates in the chart comes up as numbers, and as such, the graph always shows up with lines starting from 0 instead of the minimum date. I know we have a minimum property, but Excel understands dates and it would be nice if Access could do the same.
Stacked bars swaps the x and y, so when I want to assign a field to the X line, I have to add the field into the Y list, and visa-versa. This is somewhat frustrating.
Also, can we have a Reverse Order option because I end up having to write one query for a form I'm using, and then having to create another query with a different ORDER BY for the chart. Seems an overkill.
Lastly, I would love it if the chart title (or subtitle) could make a reference to a form text box instead of having to use the forms OnLoad or OnCurrent event to update it.