You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.