How do I visualize survey results in Excel?
To graph this data, in the Insert tab of the Excel ribbon, select Pivot Chart. In the Create Pivot Chart dialog, use the arrow button in the Table Range field to highlight your radio button response data, including the column header. Select New worksheet, then select OK.