We explain how to make a Lollipop Chart in Excel. ... A variation of a bar chart where the bar is replaced with a line and a dot at the end. ... Click the Clustered Column option under the 2-D ...

Now click outside the cell and select both cell B3 and B4 again. Using the dot at the button-right corner of the selection, pull the list down to cell B10. Fill incremental cell values in Excel ...