Any of you brilliant people have any ideas on if this can be done?  It is driving me crazy!!

Can you show us some sample data and how you have set up your Chart?
I quickly set up a chart and the months were all ordered correctly (see screenshot below).

Thanks for the reply Kevin. I can do it that way I just want it to say Jan only without the year. I want to compare two years in a column chart where each month shows 2025 & 2026 values  on the same month colimn. But I want the month to only show Jan on the x axis.

My charts is a clustered column chart.

I am just sticking to what I have. Screenshot below

I just wanted to get rid of the number below. If anyone knows how to do this, please let me know. Gemini and I couldn't figure it out!

I couldn't see any way to sort the chart the way you wanted without also showing the month number. Spent some time on ChatGPT and nothing worked. I think this is an area of Modern Charts that Microsoft really needs to work on.

One solution would be to export the data to Excel and create you chart in Excel. It has a lot more charting options than Access has.

I created a graph similar to yours BUT I created a form to input the vDate, Amount, and a vMONTH.  
On the form, in the AFTERUPDATE event of vDate I created code to fill the vMONTH field with just the month of the date entered (03Mar25--vMonth=March)  

The x-Axis then uses the vMonth and the y-Axis uses the amount.

Hope this makes sense..I've only had 3xCups of coffee

Thanks guys!  I appreciate all the effort!

Would like to see more videos on Modern Charts.  :)

-Raymond

One thing I don’t understand is why Excel has all of these cool tools but they never transition to Access. These modern charts being one of those. Why can’t Access do the same thing as Excel does with charts?

Brent Have you looked into ActiveX Chats?

TeeChart ActiveX

https://gigasoft.com/chart-activex-access

Thanks Darrin. Those look interesting but maybe way over my level of expertise.

Yeah, I've intentionally held off on making more videos on modern charts just because the Access team is still working on them. I still feel like they're a little half-baked, and as soon as they're a little more polished, I plan on doing a lot more with them. But I'll be completely honest, even I export anything but the simplest charts to Excel, because Excel has much better charting features. Like I always say, Access is good for automation data entry, storing your data. When it comes to reporting, unless it's really simple, Excel is a lot better with charts.

Richard

I've heard rumors that you can use the Excel Charting with VBA and still display it in Access....???

-Raymond

Raymond Yes, you can technically use Excel's charting engine from Access with VBA, but it's not nearly as clean as people hope it will be.

What people usually mean is automating Excel from Access. Your Access VBA code opens an instance of Excel in the background, pushes the data into a worksheet, builds the chart using Excel's chart objects, and then either displays that workbook or exports the chart as an image that you show on a form or report in Access. It works, and Excel's charting tools are vastly better than Access charts, but it adds complexity because now you're managing another application through automation.

There is also the option of embedding an Excel object on an Access form or report (OLE/ActiveX style), but that approach can be a little clunky and sometimes behaves unpredictably depending on the Office version.

In practice, for anything beyond simple charts, I usually just export the data to Excel and let Excel do what it's good at. Access is fantastic for storing the data, automating workflows, and generating datasets. Excel is still the king when it comes to charting and visualization.