Question

What allows you to show or hide ur data in the chart

Answer 1

Excel won't display hidden data in a chart unless you flip the switch. Learn which ... Select the Show Data In Hidden Rows And Columns option

Answer 2

Hey mate,

Click the Design tab. Click Select Data in the Data group. Click the Hidden And Empty Cells button (at the bottom). Select the Show Data In Hidden Rows And Columns option.

Hope it helps.