4 quadrant graph with text not numerical data

Excel cannot chart non-numeric data directly.

What you can do is assign your text values some numeric values and chat that.

Scatter charts are for finding relationships between data sets. If this is what you want to do with "Temperature" and "Rainfall", then you would be better served by using the numeric data(degrees and inches).