Another question for my stats assignment. Could use some help. Our project
is to determine if two variables are correlated. We wanted to show that
there is a correlation between public transportation ridership and median
household income.

We have twenty suburban cities selected and ridership and income data for
those cities. The professor suggested that we use a scatter plot but it
looks really funny. I was expecting to see a double axis with the name of
the city in the label on the X axis (that one runs along the bottom right?)
but I didn't. I just have three columns as seen in the example below. I used
the canned XY scatter chart. Is there another/better way to show the
correlation?

City Ridership Income
Cicero, IL 1726 $36,247