X-axis not reflecting data correctly

I am having problems with one of my graphs in a workbook I use at work.

The only graph with the issue is in the tab named 301-650 DL%.

In the graph I’m trying to get the x axis (months) and the graph data to be right at the same time. Each month is only supposed to have one dot of each color. I can either get the graph to show the data correctly with the months wrong or the months right and the graph wrong. When the graph is right April and May are represented by F and June is represented by M.

When the x axis is wrong and graph is right the axis is formated as a text axis. When the x axis is right and graph wrong the axis is formated as Automatically select based on data.

The formulas are correct from what I can tell but one weird thing is that it doesn’t highlight March even though the cell is in the formula.

Please help because this is really annoying!