Hi, I have a column that is full of Y's and N's as values. I am constantly
adding to this column so for example- on day one I might have 50 Y's and 50
N's in this column and day 2 i might have 100 Y's and 50 N's in this same
column. How do I make a chart/table in excel that will automatically give me
the current # of Y's and N's in this column as well as their respective
percentages?

So if I checked on day 1, this chart will tell me I have 50 Y's and 50 N's
(in column C for example) and that 50% of the values are Y and 50% are N. On
day two the chart will tell me I have 100 Y's and 50 N's and that 66.67% are
Y and 33.33% are N.