You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.
You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.