Line graph not showing ranking data properly

Difficult to debug a picture -- especially a picture of the desired output that doesn't show us anything about the data you have in the spreadsheet or how you have created the chart.

What you describe sounds like you have two columns of 12 numbers each. When you create the chart, Excel decides you must want those two columns of numbers charted against a generic 1, 2, 3,... x axis. The y axis extending from 0 to 2500 would be Excel's default "auto" settings for choosing axis limits for data that stretches from 14 to 2022.

The only thing I can suggest based on the description is to create the chart, then bring up the Select Data dialog. In this dialog, you can delete the "years" series from the list of data series. You can also click on the "horizontal axis" values and instruct Excel to use the column of years for the horizontal category axis labels. See if that is enough to get the chart you are looking for.

FWIW, Excel has a slightly odd quirk that you can take advantage of when using data like that, as long as your data source is not a table. Delete the contents of the header cell for the year column, then select the data and insert the chart. It should treat that first column as categories rather than data by default. Once you have the chart, just put the header value back into the cell.