To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" ...