Type your data into any cells of an Excel spreadsheet. For example, type "Hours working" into cell A1 and type "9," which is the number of hours that an employee works each day, into cell B1.

Consequently, if you hide worksheet data, Excel won’t display that data in a chart. For instance, it’s obvious from a quick look at the following chart’s legend that Tuesday’s data is missing: ...