Create a pivot table and column chart displaying the number of respondents with the different political party affiliations (PARTYID3) based on the degree held (DEGREE). For PARTYID3, 1 = Republican; 2 = Democrat; 3 = Independent. For DEGREE, 0 = Left High School; 1 = Completed High School; 2 = Completed Junior College; 3 = Completed Bachelors Degree; 4 = Completed Graduate Degree. Present data for only those respondents who provided a response for both variables

Can you tell me the steps to do this in excel and the formulas to use, as I cannot share the actual excel spreadsheet with the data here.