I'm sure there are different approaches.

The first thing to recognize is that Excel charts do not really analyze data for us. This means that, if you want a chart that shows the total net worth for each city, then the first thing you need to do is compute the net worth for each city. One approach would use a SUMIF() or SUMIFS() function https://support.office.com/en-us/art...6-611cebce642b. Another approach would use a pivot table. http://www.excel-easy.com/data-analy...ot-tables.html In order to get the number of people in each city, you can use a COUNTIF() or COUNTIFS() function https://support.office.com/en-us/art...c-aa8c2a866842 , or add a count column to your pivot table. Then build your chart from that information. Exactly how to build the chart may depend on which approach you take to get the summary data, so let's get that far.

What help do you need to get the summary data in the spreadsheet?