Close the Format Data Series pane. Now we have a lollipop chart. READ: How to create a Funnel Chart in Excel, PowerPoint, Word How do I make a lollipop chart?

The Format Data Series Pane will open on the right. Under Series Options, change the Gap Width to 50%. Now we are going to change the shape of the data series.

Customizing bar charts in Excel can include changing bar colors via the ‘Format Data Series’ option, enhancing visual appeal and making the chart more intuitive by distinguishing between ...

Excel offers many different tools for formatting your charts, but the key to success is choosing which ones to use. In this guide, I'll share some of my favorite chart-formatting hints, hopefully ...

An Excel chart with Format Data Series selected in the right-click menu, and the Gap Width option highlighted in the Format Chart Pane.