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.

Duration (number of days): How much time the task requires. ... Step 2: Make an Excel Bar Chart. To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet.