Hi, I have a spreadsheet with many rows representing records, and columns of different types of data. Column 1 indicates what region the record falls under and there are 8 regions in total. Column 2 is numerical and for each row, there's a number assigned. For example, 1 row might fall under region Japan and column 2 might have the number 17, while the next row might fall under region Southeast Asia and under column 2 it'll have the number 9. Some rows don't have numbers in column 2 at all, which indicates 0.

I want to create a chart that expresses the number of records with a number in column 2 relative to the total number of records. e.g. let's say there are 100 rows falling under region Japan, but only 56 of them have a non-zero number in column 2. Thus, the chart should show Japan at 56%. Does this make sense?

How would I go about doing this? Do I first need to create another table with formulas that calculates these percentages, then create a chart from this? If so, does someone have a sample formula I could use that helps to check through the spreadsheet for relevant rows of each region and takes note of whether they have a non-zero number in column 2?

Thanks!