Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results