Learn how to create interactive Excel dashboards that transform raw data into actionable insights with this step-by-step ...

Open a new Excel workbook and create relevant columns with data. Select Insert at the top and click Table (just a regular table first). Click My table has headers and select OK.

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.

Now, you have to enter P, A, and H manually. That’s it. I hope this helps. How do I create a checklist box in Excel? The Checklist feature is available in Microsoft Office 365 and Excel for the Web.