I've tried to calculate the correlation between credit to GDP and stick market capitalisation to GDP for China using global financial development data bank.I have to use excel and diagrammatically illustrate the relationship of the two variables using a scatteplot ?Could help me to do the graphic And how I can analyse the other data ?

Preview Clear Selection | Add Country (1) Add Series (7) Add Time (15) China V 2000 2001 2002 2003 20( Private credit by deposit money banks and other financial institutions 111.0 109.9 117.3 125.5 to GDP (%) Private credit by deposit money banks to GDP (%) 111.0 109.9 117.3 125.5 Bank deposits to GDP (%) 38.4 39.8 44.0 46.8 Bank concentration (%) 34.3 46.2 42.2 69.6 Liquid liabilities to GDP (%) 135.6 141.1 145.4 153.6 Stock market total value traded to GDP (%) 62.1 34.6 23.0 23.4 Stock market capitalization to GDP (%) 30.9 Source: Global Financial Development. Click on a metadata icon for original source information to be used for citation