We hope this tutorial helps you understand how to create a Lollipop Chart in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.

You can do this by creating a summary chart, which uses subtotals from columns of data rather than data in individual cells. Select the cells that contain your data. Click "Data" in the Excel ribbon.

then let Excel create several charts to compare the totals. All you have to do now is enter the data. 4. With the same cells still highlighted, click the ‘center’ icon in the Alignment group ...