I replaced the date in H1 with the text string " May" and the change occurred. ( reformatting to "mmmm" did nothing)
So I suspect it has something to do with the fact you used text instead of a date when adding your new column, the changing it to a date
I'm not savvy enough in charting to help you any further.
Sorry

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post