We explain how to make a Lollipop Chart in Excel. A Lollipop Chart resembles a Bar Chart but with a line on a point at the end.

(The menu options cited below apply specifically to Excel 2016; while this chart can also be created in Excel 2013, 2010, and 2007, the menu options may be slightly different.) 1. Convert metrics 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.