How to create a Lollipop Chart in Excel Follow the steps below to make a Lollipop chart: Launch Excel > Select the range of cells. Click the Insert tab and click the Insert Column or Bar Chart button.

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.