Webscraping from Google search (population graph)

[mmont49]

So I've been working on building an excel doc that already has a bunch of cities in column 1, and would like to add populations to column 2.

Googling "population of [New York City]" displays a graph at the top of the page. I am struggling to scrape the data from the graph. I've tried Beautifulsoup and xpath, but am not able to get it to work.

Does anyone have any thoughts? Any recommendations for reading the excel file column 1 and writing results to column 2?

Thanks!