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.

How to prepare the data in Excel A burndown chart is easy to create in Excel, but setting up the data takes a good understanding of what the chart represents.

To create a bi-directional mirror bar chart in Excel, you will have to start with the Stacked Bar In the 2-D Bar section. Here are the detailed steps to be followed.