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.
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" ...