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