Back in the Select Data Source dialog box, click the Add button again. Then, select the Duration (Days) header in the sheet for Series name.

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. Select the “Start date” column, so it’s highlighted.