Monday, July 25, 2022
HomeOperating SystemLearn how to create a Lollipop Chart in Excel

Learn how to create a Lollipop Chart in Excel


Charts are used to point out a graphical illustration of knowledge to audiences. Charts are ceaselessly utilized in companies to showcase essential information, akin to utilizing charts in advertising and marketing to explain a sale throughout the month or yr. Generally people in Microsoft Excel will create customs charts which might be completely different from the unique charts, as an example, a Lollipop chart. The Lollipop chart is just like the bar chart however has a novel look. On this tutorial, we are going to focus on the best way to create a Lollipop chart in Microsoft Excel.

What’s a Lollipop chart?

A variation of a bar chart the place the bar is changed with a line and a dot on the finish. Lollipop charts and bar charts are comparable; they make comparisons between completely different gadgets and classes.

Observe the steps under to make a Lollipop chart:

  1. Launch Excel > Choose the vary of cells.
  2. Click on the Insert tab and click on the Insert Column or Bar Chart button.
  3. Click on the Clustered Column possibility > Click on the Chart Design tab.
  4. Click on the Add Chart Component button.
  5. Hover the cursor over Error Bars and choose Commonplace Error.
  6. Proper-click the error bars within the chart, then choose Format Error Bars.
  7. Choose the Minus, No Cap, and Share choices and alter the share to 100% on the Format Error Bars pane.
  8. Click on the Fill and Line tab, select a coloration, and width, then select the Oval arrow within the Start Arrow menu.
  9. Proper-click the column bar and choose Format Knowledge Sequence from the menu.
  10. On the Fill and Line tab, choose No Fill within the Fill part and No Line within the Border part.

Shut the pane, and we’ve got a lollipop chart.

Launch Microsoft Excel.

Sort your information or use current information out of your file.

Spotlight the vary of cells containing your information.

Then click on the Insert tab and click on the Insert Column or Bar Chart button.

Click on the Clustered Column possibility below the 2-D Column.

The chart is inserted into the spreadsheet.

Be sure that the chart is chosen, then click on the Chart Design tab.

Click on the Add Chart Component button.

Hover the cursor over Error Bars and choose Commonplace Error.

A Format Errors Pane will open.

Within the Route part, choose the Minus possibility.

Within the Finish Type part, choose the No Cap possibility.

Within the Error Quantity part, choose the Share possibility after which change the share to 100%.

Nonetheless on the Format Error Bars pane.

How to create a Lollipop Chart in Excel

Click on the Fill and Line tab.

Click on the colour button and select a coloration when you need.

Change the width of the colour bar

Choose the Oval Arrow possibility from the Start Arrow drop-down menu.

An arrow with a spherical finish.

Now you could cover the column bars within the chart.

Choose the column bars, then right-click the column bar and choose Format Knowledge Sequence from the menu.

A Format Knowledge Sequence pane will open.

Guarantee it’s on the Fill and Line tab.

Within the Fill part, choose the No Fill possibility.

Within the Border part, choose the No Line possibility.

Shut the Format Knowledge Sequence pane.

Result (Lollipop Chart in Excel)

Now we’ve got a lollipop chart.

READ: Learn how to create a Funnel Chart in Excel, PowerPoint, Phrase

How do I make a lollipop chart?

Lollipop charts are custom-made utilizing the bar chart or the column; it appears to be like like a line with a stick. The tutorial on this article describes the steps in making a lollipop chart. You should utilize the lollipop chart similar to the bar chart in rating or displaying developments.

READ:

We hope this tutorial helps you perceive the best way to create a Lollipop Chart in Microsoft Excel; you probably have questions concerning the tutorial, tell us within the feedback.

How to create a Lollipop Chart in Excel

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments