Lollipop Chart

A composite chart with columns and dots

1. What is a Lollipop chart?

A lollipop chart is basically a column chart, but the column is transferred into the line with a dot marker for the data value. It shows the relationship between a numeric and a categorical variable.

When to use Lollipop chart?

A lollipop chart is typically used to compare and visualize data points along a numerical axis, similar to a bar chart. However, it is particularly useful when there is a need to emphasize specific values or highlight the highest or lowest data points. The lollipop chart combines the benefits of a bar chart with the clarity of a dot plot, making it effective for displaying ranking, comparison, and distribution of data in a visually engaging manner.

2. How to build a Lollipop chart with example

The lollipop chart effectively illustrates the sales revenue over time, utilizing a combination of data points represented as dots and their corresponding line segments, providing a clear visual depiction of revenue trends and emphasizing key high or low points within the data set.

  1. Click Click here to add your first chart

  2. In the menu, select Lollipop to create a lollipop chart

3. Lollipop Chart Config

  1. Select the database you use to create suggested in the list

  2. Choose the table containing the data you use to create, then it will show you the list of fields included in the table

  3. Drag/drop or select the X-Axis value

  4. Drag/drop or select the Y-Axis value

  5. Drag/drop or select the Legend properties (optional)

  6. Drag/drop or select the Sorting field to sort out the data in the chart (optional)

  7. Drag/drop or select the Filters field to emphasize a specific data (optional)

  8. You can see the visualization of your chart on the left side and select Settings to change the element’s settings

  • TITLE & SUBTITLE

You can change the title of the chart, choose the font, color and size of the name. You can also add the subtitle and change its format.

  • DISPLAY

Legend field contains the sub-categories that split each line into multiple lines corresponding to the categories. Each line still represents the same measure. You can change its display name or type (column, line, area, lollipop).

  • LEGEND

You can change the legend position (top, bottom, middle), input the name, choose the font, color and size of the name.

  • X AXIS

When you turn on the X Axis, you can input the Prefix, Postfix and change their format. X Axix title can also be added and change format too.

  • Y AXIS

When you turn on the X Axis, you can input the Prefix, Postfix and change their format. X Axix title can also be added and change format too. If you turn on Gridlines, you can change the size and the display of the Gridlines (solid, dash, dot,...).

  • DATA COLOR

Data color can be set auto or you can choose your favorite colors.

  • DATA LABEL

If you turn the label on, you can choose its style to perform (percent, value, raw), choose the font, color and size of the label and its position.

  • BACKGROUND

You can change the background color of the chart.

  • TOOLTIP

When you hover over a line of the chart, a text box appears to display information about the data of that line. You can change the text color, font, and background.

  • OTHER

Change the display unit, precision, and other functions

9. After building the chart visualization, click Add to create your chart.

10. Your chart will show up along with actions like sharing, editing, etc.

We hope that the above instructions will be useful to you. Let's have a look at our other articles to learn more about using other charts in data visualization with Rocket.BI.

Last updated