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.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

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.