Tableau is the most popular interactive data visualization tool, nowadays. It provides a wide variety of charts to explore your data easily and effectively. This series of guides - Tableau Playbook - will introduce all kinds of common charts in Tableau. And this guide will focus on the Lollipop Chart.
In this guide, we will learn about the lollipop chart in the following steps:
Here is a lollipop chart template from KeynoteGo. From this template, we can understand why this kind of chart is called a "lollipop" chart. The bar length represents the magnitude and color flags in the category.
The lollipop chart is a composite chart with bars and circles. It is a variant of the bar chart with a circle at the end, to highlight the data value. Like a bar chart, a lollipop chart is used to compare categorical data.
For this kind of composite chart, we are able to use more visual elements to convey information.
On the other hand, the end circle overstates the value. The lollipop chart extends the length of the bar and blurs the boundary. It makes precise comparison difficult, especially when the circle size is large or non-equal.
This dataset contains employment data by industry for 2011 and 2014 by city for Great Britain.
In this guide, we will analyze job distributions and changes in various industries.
In order to build a lollipop chart, we will use the dual axis technique to combine bars and circles.
We start with a bar chart:
Next, dual axis with a circle:
Tableau automatically converts these two views into Circle, so we need to convert the first axis back to Bar:
In the last step, let's polish this chart:
A basic lollipop chart is completed.
With the help of a lollipop chart, we can clearly compare the number of jobs in various industries. Human Health And Social Work Activities and Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles have the most significant number of jobs among all the industries.
Form another point of view, we realize that sorting and adding labels will make lollipop chart more readable. That is what we are going to do in the next section.
In this section, we will add more advanced features to enhance the express ability of lollipop chart.
First, let's build a lollipop chart as we did previously. But this lollipop chart will be a little different because it grows divergently.
To better distinguish the magnitude of growth and recession, we add diverging colors to both bars and circles.
Drag "% Change" into Marks - Color of both two marks.
An optional step is reflecting the magnitude in Size too. If you want to try, it's worth mentioning that, create a Calculated Field as
ABS(SUM([% Change])) to deal with the negative size.
Add well-formatted percentage labels on the lollipops:
Put on the finishing touches:
This lollipop chart is enhanced by many advanced features:
Aided by this advanced lollipop chart, we can easily find that Mining and Quarrying and Real Estate Activities have the highest growth rate, more than 250%; while Electricity, Gas, Steam and Air Conditioning Supply have the highest negative growth rate, exceeding -100%.
In this guide, we have learned about one of the composite charts in Tableau - Lollipop Chart.
First, we introduced the concept and characteristics of a lollipop chart. And then we learned the basic process to create a lollipop chart. In the end, we enhanced the lollipop chart with diverging, sorting, and labels.
You can download this example workbook Composite Charts from Tableau Public.
In conclusion, I have drawn a mind map to help you organize and review the knowledge in this guide.
I hope you enjoyed it. If you have any questions, you're welcome to contact me [email protected]
If you want to dive deeper into the topic or learn more comprehensively, there are many professional Tableau Training Classes on Pluralsight, such as Tableau Desktop Playbook: Building Common Chart Types.
I made a complete list of my common Tableau charts serial guides, in case you are interested:
|Categories||Guides and Links|
|Bar Chart||Bar Chart, Stacked Bar Chart, Side-by-side Bar Chart, Histogram, Diverging Bar Chart|
|Text Table||Text Table, Highlight Table, Heat Map, Dot Plot|
|Line Chart||Line Chart, Dual Axis Line Chart, Area Chart, Sparklines, Step Lines and Jump Lines|
|Standard Chart||Pie Chart|
|Derived Chart||Funnel Chart, Waffle Chart|
|Composite Chart||Lollipop Chart, Dumbbell Chart, Pareto Chart, Donut Chart|